/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 vote243 views1 answer
Dockerfile example for Django
SQL
0 vote169 views1 answer
Sql count null as 0
SQL
1 vote192 views1 answer
Last 24 HOUR data in mysql
SQL
0 vote169 views1 answer
Change schema of all tables postgres
SQL
2 votes175 views1 answer
Drop all database tables oracle sql developer
SQL
1 vote198 views4 answers
How to check table in postgresql from terminal
SQL
0 vote234 views1 answer
Sqlite update where exists
SQL
0 vote182 views1 answer
How to create a new shema using query languaage
SQL
0 vote173 views1 answer
How to add boolean column in postgresql
SQL
0 vote164 views1 answer
Mysql money value
SQL