[SQL] Count by condition

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

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

[출처] https://stackoverflow.com/questions/1400078/is-it-possible-to-specify-condition-in-count