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)

How many downloads of ep and album respectively?
SELECT SUM(totalsnatched) FROM torrents WHERE releasetype = "ep" UNION SELECT SUM(totalsnatched) FROM torrents WHERE releasetype = "album"
SELECT SUM("totalsnatched") FROM "torrents" WHERE "ep" = "releasetype" UNION SELECT SUM("totalsnatched") FROM "torrents" WHERE "album" = "releasetype"