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)

What are the downloaded numbers and their release types?
SELECT SUM(totalsnatched), releasetype FROM torrents GROUP BY releasetype
SELECT SUM("totalsnatched"), "releasetype" FROM "torrents" GROUP BY "releasetype"