select count(case Position when 'Manager' then 1 else null end) from ... select sum(case Position when 'Manager' then 1 else 0 end) from ...
SELECT COUNT(column_name) FROM table_name WHERE condition;