Task: Text to Code
Input (English): Step 1: For each row in trip table, find the corresponding rows in weather table.
Step 2: find each value of weather's zip_code in the results of step 1 along with the number of the corresponding rows to each value
Output (English): SELECT Count ( * ) , T1.zip_code FROM trip AS T1 JOIN weather AS T2 GROUP BY T2.zip_code