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

What are name of top 10 artists or groups?
SELECT artist FROM torrents GROUP BY artist ORDER BY SUM(totalsnatched) DESC LIMIT 10
SELECT "artist" FROM "torrents" GROUP BY "artist" ORDER BY SUM("totalsnatched") DESC NULLS LAST LIMIT 10