CREATE TABLE table_204_239 (id NUMBER, "year" NUMBER, "title" CLOB, "uk" CLOB, "us:\ billboard\ hot 100" CLOB, "us:\ billboard\ r&b" CLOB, "us:\ billboard\ a/c" CLOB, "australia" CLOB, "various" CLOB)

which year does the artist have the most charted singles ?
SELECT "year" FROM table_204_239 GROUP BY "year" ORDER BY COUNT("title") DESC LIMIT 1
SELECT "year" FROM "table_204_239" GROUP BY "year" ORDER BY COUNT("title") DESC FETCH FIRST 1 ROWS ONLY