Condition in count sql

select count(case Position when 'Manager' then 1 else null end)
from ...


select sum(case Position when 'Manager' then 1 else 0 end)
from ...

Sql count if

COUNT(CASE WHEN <condition> THEN 1 END)

-1

Source: modern-sql.com

Sql count condition

SELECT count(CASE WHEN gender = 'F' THEN 1 ELSE NULL END) women_count,
       count(CASE WHEN gender = 'M' THEN 1 ELSE NULL END) men_count
FROM people;

-2

Similar codes

2 votes258 views3 answers
How to get second highest salary in each department in sql
SQL
3 votes575 views1 answer
Postgresql cast
SQL
6 votes277 views1 answer
Postgres get size of database
SQL
0 vote275 views1 answer
How to select only id where is not in column mysql
SQL
0 vote301 views1 answer
Psql initialization
SQL
0 vote285 views1 answer
Postgres grep entire database
SQL
1 vote283 views1 answer
Mysql how to truncate table with foreign keys
SQL
12 votes267 views4 answers
Install mysql ubuntu 18.04
SQL
10 votes295 views2 answers
Mysql remove only_full_group_by permanently
SQL
1 vote289 views1 answer
Sql insert for each distinct value
SQL