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)

What are the top 100 torrent releases?
SELECT groupname FROM torrents ORDER BY totalsnatched DESC LIMIT 100
SELECT "groupname" FROM "torrents" ORDER BY "totalsnatched" DESC FETCH FIRST 100 ROWS ONLY