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