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)

Find me top 10 albums ranked by their popularity.
SELECT groupname FROM torrents WHERE releasetype = "album" ORDER BY totalsnatched DESC LIMIT 10
SELECT "groupname" FROM "torrents" WHERE "album" = "releasetype" ORDER BY "totalsnatched" DESC FETCH FIRST 10 ROWS ONLY