Find the number of team franchises that are active (have 'Y' as "active" information).
return team franchises ;return active information of  #1 ;return #1 where  #2 is  'Y ;return number of #3
['select', 'project', 'comparative', 'aggregate']