Show the zip codes and average mean visibilities.
select zip_code, mean_visibility_miles from weather
Find the zip code in which the average mean visibility is lower than 10.
select zip_code from weather group by zip_code having avg(mean_visibility_miles) < 10