/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

13 votes182 views3 answers
List all the tables in sql
SQL
5 votes169 views1 answer
Oracle add time to date
SQL
1 vote148 views2 answers
How to check username in mysql command line
SQL
0 vote189 views1 answer
Sql alter column name sql server
SQL
0 vote149 views1 answer
Execut sql python
SQL
1 vote170 views1 answer
Oracle drop temporary table
SQL
2 votes164 views1 answer
Express api ith mysql data
SQL
0 vote179 views1 answer
Oracle execute package dblink
SQL
8 votes146 views3 answers
Duplicate entry
SQL
0 vote225 views1 answer
Sqlite schema structure of a relational database
SQL