For each zip code, return how many times max wind speed reached 25?
CREATE TABLE weather (zip_code VARCHAR, max_wind_Speed_mph VARCHAR)
SELECT zip_code, COUNT(*) FROM weather WHERE max_wind_Speed_mph >= 25 GROUP BY zip_code
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE weather (zip_code VARCHAR, max_wind_Speed_mph VARCHAR) Question: For each zip code, return how many times max wind speed reached 25? [/INST] SELECT zip_code, COUNT(*) FROM weather WHERE max_wind_Speed_mph >= 25 GROUP BY zip_code </s>