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)

What are the top 10 torrent release types?
SELECT releasetype FROM torrents GROUP BY releasetype ORDER BY SUM(totalsnatched) DESC LIMIT 10
SELECT "releasetype" FROM "torrents" GROUP BY "releasetype" ORDER BY SUM("totalsnatched") DESC FETCH FIRST 10 ROWS ONLY