/SQL/Case when with count and combining similar values in sql

Case when with count and combining similar values in sql

SELECT 
    data.id,
    data.lastname,
    data.firstname,
    SUM(data.WebData) AS WebData,
    SUM(data.InternalData) AS InternalData,
    SUM(data.countid) AS Countid
FROM
    (
       SELECT id,lastname,
              firstname,datasource,
              CASE WHEN Datasource = 'Web' THEN Count(Datasource) ELSE 0 END WebData,
              CASE WHEN Datasource = 'Internal' THEN Count(Datasource)ELSE 0 END InternalData,
             count(id) AS Countid

        FROM Table
        GROUP BY
                 id,lastname,firstname,datasource
     ) AS data
GROUP BY 
    data.id,data.firstname,data.lastname

Source: stackoverflow.com

Similar codes

0 vote228 views1 answer
Contact mysql column field
SQL
4 votes294 views1 answer
Oracle table statistics
SQL
3 votes254 views3 answers
1396(hy00) mysql error
SQL
3 votes235 views1 answer
Null sql
SQL
19 votes231 views6 answers
Sql server drop table if exists
SQL
3 votes219 views1 answer
MySQL DELETE JOIN
SQL
0 vote285 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
0 vote230 views1 answer
Query string starts with vowels
SQL
0 vote235 views1 answer
Create dump file mysql workbench
SQL
3 votes236 views1 answer
Define REGEXP?
SQL