/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

15 votes356 views4 answers
Sql update from select
SQL
0 vote320 views1 answer
Google cloud sql postgres url example
SQL
-2 votes333 views1 answer
Mysql see users and passwords
SQL
50 votes409 views6 answers
Install mysql on ubuntu
SQL
1 vote347 views1 answer
Mysql drop key
SQL
0 vote345 views1 answer
Like sql for second letter of the family name
SQL
0 vote333 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote342 views1 answer
Oracle lower in where clause
SQL
0 vote319 views4 answers
Sql limit 1 offset 1
SQL
0 vote316 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL