CREATE TABLE table_204_854 (id NUMBER, "#" NUMBER, "wrestlers" CLOB, "reign" NUMBER, "date" CLOB, "days\ held" NUMBER, "location" CLOB, "notes" CLOB)

what location hosted more , osaka or tokyo ?
SELECT "location" FROM table_204_854 WHERE "location" IN ('osaka', 'tokyo') GROUP BY "location" ORDER BY COUNT(*) DESC LIMIT 1
SELECT "location" FROM "table_204_854" WHERE "location" IN ('osaka', 'tokyo') GROUP BY "location" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY