CREATE TABLE table_204_780 (id NUMBER, "year" NUMBER, "competition" CLOB, "venue" CLOB, "position" CLOB, "notes" CLOB)

which position was held the most number of times ?
SELECT "position" FROM table_204_780 GROUP BY "position" ORDER BY COUNT(*) DESC LIMIT 1
SELECT "position" FROM "table_204_780" GROUP BY "position" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY