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 downloaded numbers and their release types?
SELECT SUM(totalsnatched), releasetype FROM torrents GROUP BY releasetype
SELECT SUM("totalsnatched"), "releasetype" FROM "torrents" GROUP BY "releasetype"