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
days with mean humidity above 50 refers to mean_humidity > 50; days with mean visibility above 8 refers to mean_visibility_miles > 8; counting such days refers to COUNT(*);