How many schools won their last occ championship in 2006?
CREATE TABLE table_17429402_7 (school VARCHAR, last_occ_championship VARCHAR)
SELECT COUNT(school) FROM table_17429402_7 WHERE last_occ_championship = "2006"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_17429402_7 (school VARCHAR, last_occ_championship VARCHAR) Question: How many schools won their last occ championship in 2006? [/INST] SELECT COUNT(school) FROM table_17429402_7 WHERE last_occ_championship = "2006" </s>