Task: Text to Code
Input (English): What are the zip codes that have an average mean humidity below 70 and had at least 100 trips come through there?
Output (English): SELECT zip_code FROM weather GROUP BY zip_code HAVING avg(mean_humidity)  <  70 INTERSECT SELECT zip_code FROM trip GROUP BY zip_code HAVING count(*)  >=  100