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

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 NULLS LAST LIMIT 10