Find the zip code in which the average mean visibility is lower than 10.
CREATE TABLE weather (zip_code VARCHAR, mean_visibility_miles INTEGER)
SELECT zip_code FROM weather GROUP BY zip_code HAVING AVG(mean_visibility_miles) < 10
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE weather (zip_code VARCHAR, mean_visibility_miles INTEGER) Question: Find the zip code in which the average mean visibility is lower than 10. [/INST] SELECT zip_code FROM weather GROUP BY zip_code HAVING AVG(mean_visibility_miles) < 10 </s>