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