How many team franchises are active, with active value 'Y'?
select count(*) from team_franchise where active = 'Y';