CREATE TABLE trip (bike_id VARCHAR2, zip_code VARCHAR2)

Which bike traveled the most often in zip code 94002?
SELECT bike_id FROM trip WHERE zip_code = 94002 GROUP BY bike_id ORDER BY COUNT(*) DESC LIMIT 1
SELECT "bike_id" FROM "trip" WHERE "zip_code" = 94002 GROUP BY "bike_id" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY