How many team franchises are active, with active value 'Y'?
SELECT count(*) FROM team_franchise WHERE active = 'Y';
active team franchises refers to active = 'Y'; count of active team franchises refers to count(*);