Database: bike_1
Question: For each zip code, select all those that have an average mean visiblity below 10.
SQL:
SELECT zip_code FROM weather GROUP BY zip_code HAVING avg(mean_visibility_miles)  <  10