/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 vote110 views1 answer
Sql query for displaying age from oldest to youngest
SQL
1 vote109 views1 answer
Round one decimal place mysql
SQL
8 votes96 views3 answers
Alter table auto_increment
SQL
1 vote108 views1 answer
How to set up a trigger in sql
SQL
4 votes95 views2 answers
Postgresql reset sequence
SQL
0 vote106 views1 answer
Postgres create extension if not exists
SQL
3 votes103 views2 answers
Sql asc
SQL
0 vote113 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote103 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote101 views1 answer
Sql case when exists in another table
SQL