CREATE TABLE tags (index NUMBER, id NUMBER, tag CLOB)
CREATE TABLE torrents (groupname CLOB, totalsnatched NUMBER, artist CLOB, groupyear NUMBER, releasetype CLOB, groupid NUMBER, id NUMBER)

what year was each specific entry released?
SELECT groupname, groupyear FROM torrents
SELECT "groupname", "groupyear" FROM "torrents"