what is the zip code of the highest number of trips taken | What do you mean by "highest number of trips taken"? | i would like to know the zip code of trips taken above 200 with humidity below 70
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 ( * )    > =    200
highest number of trips taken refers to MAX(count(trips)); zip code of trips taken above 200 refers to HAVING COUNT(*) >= 200; humidity below 70 refers to HAVING AVG(mean_humidity) < 70;