CREATE TABLE table_204_604 (id NUMBER, "year" NUMBER, "date" CLOB, "driver" CLOB, "team" CLOB, "manufacturer" CLOB, "race distance\ laps" NUMBER, "race distance\ miles  ( km ) " CLOB, "race time" CLOB, "average speed\ ( mph ) " NUMBER, "report" CLOB)

which manufacturer has the most number of wins at the auto club 400 between 1997 and 2014 ?
SELECT "manufacturer" FROM table_204_604 GROUP BY "manufacturer" ORDER BY COUNT(*) DESC LIMIT 1
SELECT "manufacturer" FROM "table_204_604" GROUP BY "manufacturer" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY