How many cities have a stadium that was opened before the year of 2006?
CREATE TABLE stadium (city VARCHAR, opening_year INTEGER)
SELECT COUNT(DISTINCT city) FROM stadium WHERE opening_year < 2006
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE stadium (city VARCHAR, opening_year INTEGER) Question: How many cities have a stadium that was opened before the year of 2006? [/INST] SELECT COUNT(DISTINCT city) FROM stadium WHERE opening_year < 2006 </s>