/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 vote184 views1 answer
How to add timestamp column in mysql
SQL
13 votes186 views2 answers
Get date from now() mysql
SQL
1 vote238 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
3 votes189 views1 answer
Convert sqlite table to pandas dataframe
SQL
8 votes238 views3 answers
Postgres database sizes
SQL
3 votes185 views1 answer
How to check schema privileges in oracle
SQL
1 vote174 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote186 views1 answer
Mysql db dump restore max file size issue
SQL
11 votes186 views1 answer
Sql query to find duplicates in column
SQL
3 votes230 views1 answer
Delete all content in table mysql
SQL