Database: bike_1
Question: For each zip code, return how many times max wind speed reached 25?
SQL:
SELECT zip_code , count(*) FROM weather WHERE max_wind_Speed_mph  >=  25 GROUP BY zip_code