CODE EXAMPLE FOR SQL

count with where

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