-- Database schema
| station : id [ INT ] primary_key , name [ TEXT ] , lat [ INT ] , long [ INT ] , dock_count [ INT ] , city [ TEXT ] , installation_date [ TEXT ] | status : station_id [ INT ] status.station_id = station.id , bikes_available [ INT ] , docks_available [ INT ] , time [ TEXT ] | trip : id [ INT ] primary_key , duration [ INT ] , start_date [ TEXT ] , start_station_name [ TEXT ] , start_station_id [ INT ] , end_date [ TEXT ] , end_station_name [ TEXT ] , end_station_id [ INT ] , bike_id [ INT ] , subscription_type [ TEXT ] , zip_code [ INT ] | weather : date [ TEXT ] , max_temperature_f [ INT ] , mean_temperature_f [ INT ] , min_temperature_f [ INT ] , max_dew_point_f [ INT ] , mean_dew_point_f [ INT ] , min_dew_point_f [ INT ] , max_humidity [ INT ] , mean_humidity [ INT ] , min_humidity [ INT ] , max_sea_level_pressure_inches [ INT ] , mean_sea_level_pressure_inches [ INT ] , min_sea_level_pressure_inches [ INT ] , max_visibility_miles [ INT ] , mean_visibility_miles [ INT ] , min_visibility_miles [ INT ] , max_wind_Speed_mph [ INT ] , mean_wind_speed_mph [ INT ] , max_gust_speed_mph [ INT ] , precipitation_inches [ INT ] , cloud_cover [ INT ] , events [ TEXT ] , wind_dir_degrees [ INT ] , zip_code [ INT ] |
-- -- What zip codes have a station with a max temperature greater than or equal to 80 and when did it reach that temperature?

SELECT date ,  zip_code FROM weather WHERE max_temperature_f  >=  80;