How many team franchises are active, with active value 'Y'?
CREATE TABLE team_franchise (active VARCHAR)
SELECT COUNT(*) FROM team_franchise WHERE active = 'Y'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE team_franchise (active VARCHAR) Question: How many team franchises are active, with active value 'Y'? [/INST] SELECT COUNT(*) FROM team_franchise WHERE active = 'Y' </s>