/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

1 vote434 views1 answer
STOP message of how many rows affected sql
SQL
6 votes353 views1 answer
Update left join mysql
SQL
3 votes375 views1 answer
DB: in eloquent using sql
SQL
6 votes335 views1 answer
Phpmyadmin reset root password
SQL
0 vote303 views1 answer
Mysql select top 2
SQL
1 vote384 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
37 votes365 views3 answers
Duplicate records in sql
SQL
0 vote372 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote335 views1 answer
Oracle last connection
SQL
0 vote374 views1 answer
Php mysqli install
SQL