/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 vote280 views1 answer
Oracle lower in where clause
SQL
0 vote265 views1 answer
Mysql order by where condition sub query
SQL
1 vote212 views1 answer
Oracle compile schema
SQL
1 vote286 views1 answer
Write a query to create an empty table from an existing table?
SQL
0 vote254 views1 answer
Mariadb mysql root access denied
SQL
0 vote295 views1 answer
SQL-Arten
SQL
2 votes249 views1 answer
Oracle sql query to make column data uppercase
SQL
6 votes226 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote249 views1 answer
Wordpress sql change site url
SQL
24 votes283 views6 answers
Alter table name sql
SQL