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 are the entries by each specific artist/group?
SELECT groupname, artist FROM torrents
SELECT "groupname", "artist" FROM "torrents"