CREATE TABLE torrents (groupname CLOB, totalsnatched NUMBER, artist CLOB, groupyear NUMBER, releasetype CLOB, groupid NUMBER, id NUMBER)
CREATE TABLE tags (index NUMBER, id NUMBER, tag CLOB)

Which year has the most CDs released?
SELECT groupyear FROM torrents GROUP BY groupyear ORDER BY COUNT(groupname) DESC LIMIT 1
SELECT "groupyear" FROM "torrents" GROUP BY "groupyear" ORDER BY COUNT("groupname") DESC FETCH FIRST 1 ROWS ONLY