/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 vote200 views1 answer
Mysql 8 geo to json
SQL
0 vote234 views1 answer
How to get table id sequence postgres
SQL
1 vote181 views1 answer
Check message id sql server
SQL
0 vote200 views2 answers
How to add CHECK constraint to a column in postgres
SQL
0 vote191 views1 answer
Oracle character index
SQL
3 votes193 views1 answer
Oracle APEX elapsed time
SQL
6 votes231 views5 answers
Oracle list tablespaces
SQL
8 votes198 views1 answer
Script to add datafile to tablespace
SQL
0 vote185 views1 answer
Update sqlite
SQL
0 vote204 views1 answer
Is not sql
SQL