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
Give me the zip code where the average mean humidity is below 70 and at least 100 trips took place.
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
select zip_code from weather group by zip_code having avg ( mean_humidity ) < value intersect select zip_code from trip group by zip_code having count ( * ) > = value
Give me the zip code where the average mean humidity is below 70 and at least 100 trips took place .