/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 vote152 views2 answers
How to use aggregate functions in sql
SQL
0 vote140 views1 answer
Power query case when
SQL
0 vote220 views1 answer
Connect google bigquery connect using sqirrel
SQL
1 vote143 views1 answer
Postgresql convert text to float
SQL
0 vote224 views1 answer
Sql trigger to call stored procedure with parameters
SQL
5 votes190 views3 answers
Sql limit offset
SQL
8 votes148 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote138 views1 answer
Sqldf change user
SQL
0 vote141 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
0 vote252 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL