SELECT zip_code FROM weather GROUP BY zip_code HAVING avg(mean_visibility_miles)  <  10
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
select zip_code from weather group by zip_code having avg ( mean_visibility_miles ) < value
Find the zip code in which the average mean visibility is lower than 10 .