/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

2 votes176 views4 answers
Duplicate record mysql
SQL
2 votes201 views1 answer
Search query in mysql
SQL
0 vote198 views1 answer
Mariadb change column type
SQL
1 vote182 views1 answer
Sql count value greater than
SQL
0 vote208 views1 answer
SQL-Arten
SQL
0 vote191 views1 answer
Sqlite trim
SQL
0 vote183 views1 answer
Many rows to 1 string mysql
SQL
3 votes185 views1 answer
Oracle user privileges
SQL
0 vote183 views1 answer
Mysql set column equal to another automatic
SQL
1 vote191 views1 answer
Oracle turn off constraint
SQL