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)

Which albums have been downloaded more than 100 times?
SELECT DISTINCT groupname FROM torrents WHERE totalsnatched > 100 AND releasetype = "album"
SELECT DISTINCT "groupname" FROM "torrents" WHERE "album" = "releasetype" AND "totalsnatched" > 100