sql - Is it possible to specify condition in Count()? - Stack Overflow

select count(case Position when 'Manager' then 1 else null end) from ... You can also use the sum ...

stackoverflow.com