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 vote232 views1 answer
Sql express database size limit
SQL
2 votes227 views1 answer
Install postgresql centos 5
SQL
11 votes205 views2 answers
Set default column value sql
SQL
0 vote196 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
0 vote203 views1 answer
Date on SQL
SQL
0 vote219 views1 answer
Primary key start from number
SQL
2 votes218 views5 answers
Install postgresql 10 centos 7
SQL
3 votes222 views1 answer
Async await mysql nodejs
SQL
0 vote217 views2 answers
How covert into int in maria db
SQL
0 vote190 views1 answer
Sql random decimal
SQL