SELECT count(*) FROM team_franchise WHERE active = 'Y';
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 = value
Find the number of team franchises that are active ( have 'Y ' as `` active '' information ) .