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

what are the entries by each specific artist/group?
SELECT groupname, artist FROM torrents
SELECT "groupname", "artist" FROM "torrents"