Multiple count in sql

SELECT distributor_id,
    count(*) AS Total,
    sum(CASE WHEN inflevel = 'exec' THEN 1 ELSE 0 END) AS ExecCount,
    sum(CASE WHEN inflevel = 'personal' THEN 1 ELSE 0 END) AS PersonalCount
FROM yourtable
GROUP BY distributor_id

Source: stackoverflow.com

Similar codes

0 vote251 views1 answer
Sqlite trim
SQL
10 votes247 views2 answers
What is database
SQL
0 vote246 views1 answer
Psql get table data types
SQL
3 votes245 views1 answer
Null sql
SQL
-1 vote229 views1 answer
Count occurrences sql
SQL
10 votes233 views5 answers
Between keyword in sql
SQL
0 vote252 views1 answer
Sql alchemy escape ; in insert statement
SQL
8 votes242 views1 answer
Today minus 15 days postgresql
SQL
0 vote203 views1 answer
Big query add table rows to another table
SQL
0 vote238 views1 answer
Mysql select field if condition
SQL