When 1 active, 1 inactive is the canadian chapters how many founding dates are there?
CREATE TABLE table_28436909_4 (founding_date VARCHAR, canadian_chapters VARCHAR)
SELECT COUNT(founding_date) FROM table_28436909_4 WHERE canadian_chapters = "1 Active, 1 Inactive"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_28436909_4 (founding_date VARCHAR, canadian_chapters VARCHAR) Question: When 1 active, 1 inactive is the canadian chapters how many founding dates are there? [/INST] SELECT COUNT(founding_date) FROM table_28436909_4 WHERE canadian_chapters = "1 Active, 1 Inactive" </s>