For each zip code, select all those that have an average mean visiblity below 10.
SELECT zip_code FROM weather GROUP BY zip_code HAVING avg(mean_visibility_miles)  <  10
select all those that have = GROUP BY zip_code HAVING; average mean visibility below 10 refers to avg(mean_visibility_miles) < 10;