CREATE TABLE table_203_652 (id NUMBER, "goal" NUMBER, "date" CLOB, "venue" CLOB, "opponent" CLOB, "score" CLOB, "result" CLOB, "competition" CLOB)

which type of competition was listed the most ?
SELECT "competition" FROM table_203_652 GROUP BY "competition" ORDER BY COUNT(*) DESC LIMIT 1
SELECT "competition" FROM "table_203_652" GROUP BY "competition" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY