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

2 votes128 views1 answer
How to delete view in sql
SQL
32 votes140 views6 answers
Insert into values select
SQL
1 vote266 views3 answers
Sql subquery
SQL
0 vote146 views1 answer
Postgres list all triggers
SQL
0 vote127 views1 answer
Sqlite explain plan
SQL
0 vote141 views1 answer
Mysql change innodb to myisam
SQL
0 vote161 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
2 votes134 views1 answer
Date conversion in mysql column
SQL
0 vote117 views1 answer
The local psql command could not be located
SQL
7 votes137 views1 answer
Sql server management studio turn on line numbers
SQL