CREATE TABLE weather (zip_code VARCHAR, mean_visibility_miles INT)

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") < 10