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 year was each specific entry released?
SELECT groupname, groupyear FROM torrents
SELECT "groupname", "groupyear" FROM "torrents"