What is the number of days that had an average humity above 50 and an average visibility above 8?
select count(*) from weather where mean_humidity > 50 and mean_visibility_miles > 8