/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 vote213 views1 answer
Mariadb current date plus 1 day
SQL
11 votes206 views2 answers
Set default column value sql
SQL
0 vote194 views1 answer
Truncate a table then insert data
SQL
4 votes227 views1 answer
Mysql store ip address
SQL
1 vote212 views1 answer
Sql server insert into temp table
SQL
0 vote214 views1 answer
Psql generate id in existing database
SQL
0 vote218 views2 answers
How to prevent sql injection in java
SQL
0 vote208 views1 answer
Flask sqlalchemy remove duplicates
SQL
0 vote223 views1 answer
Delete duplicate rows
SQL
1 vote206 views1 answer
Hexadec to sql REDSHIFT
SQL