/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 vote182 views1 answer
Scaffold mysql database
SQL
8 votes175 views1 answer
Oracle current date plus 1 month
SQL
1 vote200 views2 answers
Mysql update table from another table
SQL
1 vote221 views1 answer
Oracle select row max date
SQL
1 vote216 views1 answer
Postgres get month name from date
SQL
18 votes199 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote202 views1 answer
Get the next column of a table in mysql
SQL
1 vote201 views2 answers
Postgresql backup and restore globals and data
SQL
0 vote190 views2 answers
Auto increment column in mysql query results
SQL
1 vote202 views1 answer
Decalre temp table sql
SQL