How many days had both mean humidity above 50 and mean visibility above 8?
select count(*) from weather where mean_humidity > 50 and mean_visibility_miles > 8