/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

5 votes172 views2 answers
Get columns number sql
SQL
0 vote144 views1 answer
Sqlite closes value
SQL
0 vote160 views4 answers
Mysql replace regex
SQL
1 vote227 views1 answer
SQL server query column yes or no
SQL
31 votes171 views2 answers
Grant all priviledges to mysql user
SQL
0 vote140 views1 answer
Opensuse stop MySQL
SQL
0 vote158 views1 answer
Big table in mysql
SQL
0 vote166 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote143 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote187 views1 answer
Tsql cte in a transaction
SQL