/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

7 votes349 views2 answers
Mysql db size
SQL
4 votes413 views2 answers
Sql display today's date
SQL
0 vote439 views1 answer
Sqlite display data in separated columns
SQL
0 vote341 views1 answer
Time mysql w3
SQL
3 votes335 views4 answers
Show columns from table
SQL
1 vote327 views2 answers
T-sql random number for each row
SQL
8 votes320 views3 answers
Duplicate entry
SQL
0 vote372 views1 answer
Mql5 datetime get hour
SQL
0 vote349 views1 answer
Qt qsql check if table exist
SQL
0 vote340 views2 answers
Create new table plsql
SQL