Table schema:
CREATE TABLE team_franchise (active VARCHAR)

Question: How many team franchises are active, with active value 'Y'?
SQL: SELECT COUNT(*) FROM team_franchise WHERE active = 'Y'