Show the records of weather events with both mean humidity above 50 and mean visibility above 8.
select * from weather where mean_humidity > 50 and mean_visibility_miles > 8
Count those days.
select count(*) from weather where mean_humidity > 50 and mean_visibility_miles > 8