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 is the torrent download statistics for each release year?
SELECT SUM(totalsnatched), groupyear FROM torrents GROUP BY groupyear
SELECT SUM("totalsnatched"), "groupyear" FROM "torrents" GROUP BY "groupyear"