/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 vote189 views1 answer
If column value is null then in mysql
SQL
4 votes189 views1 answer
Refresh postgres config
SQL
4 votes192 views5 answers
Primary key
SQL
0 vote185 views1 answer
Mysql_error replacement
SQL
0 vote173 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
9 votes175 views3 answers
Show table columns mysql command line
SQL
4 votes182 views1 answer
Sql query to make a existing column auto increment
SQL
1 vote200 views1 answer
Sql current timestamp
SQL
0 vote195 views1 answer
Drop column from table if exist on live server mysql
SQL
1 vote172 views1 answer
Postgresql export output table as a csv
SQL