When and in what zip code did max temperature reach 80?
SELECT date ,  zip_code FROM weather WHERE max_temperature_f  >=  80
max temperature reach 80 refers to max_temperature_f >= 80; when refers to date; in what zip code refers to zip_code;