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

Which kind of release type is the most popular?
SELECT releasetype FROM torrents GROUP BY releasetype ORDER BY SUM(totalsnatched) DESC LIMIT 1
SELECT "releasetype" FROM "torrents" GROUP BY "releasetype" ORDER BY SUM("totalsnatched") DESC FETCH FIRST 1 ROWS ONLY