SELECT zip_code FROM weather GROUP BY zip_code HAVING AVG(mean_visibility_miles) < 10
Temukan kode pos di mana visibilitas rata -rata rata -rata lebih rendah dari 10.
CREATE TABLE weather (zip_code VARCHAR, mean_visibility_miles INTEGER)