Task: Text to Code
Input (English): What is the number of days that had an average humity above 50 and an average visibility above 8?
Output (English): SELECT COUNT(*) FROM weather WHERE mean_humidity  >  50 AND mean_visibility_miles  >  8