/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 vote205 views1 answer
Oracle create_program
SQL
0 vote188 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
1 vote185 views1 answer
Postgres check blocking
SQL
1 vote214 views1 answer
Postgresql round double precision
SQL
7 votes285 views2 answers
Sql empty table
SQL
1 vote227 views1 answer
Does insert into overwrite sql
SQL
0 vote184 views1 answer
Set column width in sqlplus
SQL
0 vote253 views1 answer
Postgres rename database
SQL
0 vote206 views1 answer
Postgresql import a database of gzip
SQL
0 vote200 views1 answer
Sql server count all tables rows
SQL