/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 vote302 views1 answer
Mysql coalesce
SQL
1 vote250 views1 answer
Convert money to varchar sql server
SQL
4 votes328 views2 answers
Postgre sql create table
SQL
0 vote334 views1 answer
Mysql subtract month from timestamp
SQL
1 vote336 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
1 vote321 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
3 votes327 views4 answers
Stop MySQL
SQL
4 votes308 views1 answer
Mysql biginteger size
SQL
9 votes327 views3 answers
Show table columns mysql command line
SQL
0 vote332 views2 answers
Timing sql queries
SQL