Find the number of team franchises that are active (have 'Y' as "active" information).
select count(*) from team_franchise where active = 'Y';