SELECT count(*) FROM team_franchise WHERE active = 'Y';
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 = value
How many team franchises are active , with active value 'Y ' ?