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)

Name the most popular release on houston.
SELECT T2.groupname FROM torrents AS T2 JOIN tags AS T1 ON T1.id = T2.id WHERE T1.tag = "houston" ORDER BY totalsnatched DESC LIMIT 1
SELECT "T2"."groupname" FROM "torrents" "T2" JOIN "tags" "T1" ON "T1"."id" = "T2"."id" AND "T1"."tag" = "houston" ORDER BY "totalsnatched" DESC FETCH FIRST 1 ROWS ONLY