/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

6 votes151 views2 answers
Sql query to get the number of rows in a table
SQL
2 votes169 views2 answers
Install postgresql
SQL
19 votes137 views4 answers
Rename database in sql
SQL
6 votes145 views1 answer
How to count number of rows in sql
SQL
0 vote108 views1 answer
Mysql offset from bottom
SQL
0 vote187 views1 answer
Store case result sql
SQL
2 votes131 views1 answer
How to add where command in update comand with joins
SQL
1 vote141 views1 answer
Oracle difference between two dates in years
SQL
0 vote138 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote135 views2 answers
Homebrew nysql launch
SQL