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)

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