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 artist release the most CDs?
SELECT artist FROM torrents GROUP BY artist ORDER BY COUNT(groupname) DESC LIMIT 1
SELECT "artist" FROM "torrents" GROUP BY "artist" ORDER BY COUNT("groupname") DESC FETCH FIRST 1 ROWS ONLY