Find the number of team franchises that are active (have 'Y' as "active" information).
SELECT count(*) FROM team_franchise WHERE active = 'Y';
SELECT count(*) FROM team_franchise WHERE active = 'Y';
[{'count(*)': 30}]