/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

33 votes427 views6 answers
Sql delete
SQL
0 vote341 views2 answers
Sql if empty then
SQL
0 vote337 views1 answer
Sql select most frequent value in group
SQL
0 vote335 views1 answer
Minecraft duping allowed servers
SQL
4 votes298 views1 answer
Oracle sleep
SQL
6 votes341 views2 answers
Mysql version check cmd
SQL
0 vote375 views1 answer
What is top n result in sql
SQL
0 vote357 views5 answers
Select concat alter table mysql
SQL
2 votes335 views2 answers
Install sqlalchemy
SQL
0 vote378 views1 answer
Mysql case when on date
SQL