Task: Text to Code
Input (English): Step 1: find the rows in weather table whose zip_code equals 94107.
Step 2: find each value of zip_code in the results of step 1 ordered descending by number of rows that correspond of each value.
Step 3: only show the first 3 rows of the results
Output (English): SELECT zip_code FROM weather WHERE zip_code = 94107 GROUP BY zip_code ORDER BY Count ( * ) Desc LIMIT 3