CREATE TABLE team_franchise (active VARCHAR2)

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