1select count(case Position when 'Manager' then 1 else null end)
2from ...
3
4
5select sum(case Position when 'Manager' then 1 else 0 end)
6from ...
1SELECT count(CASE WHEN gender = 'F' THEN 1 ELSE NULL END) women_count,
2 count(CASE WHEN gender = 'M' THEN 1 ELSE NULL END) men_count
3FROM people;