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

Find me the most popular topics since 2010.
SELECT T1.tag FROM torrents AS T2 JOIN tags AS T1 ON T1.id = T2.id WHERE T2.groupyear >= 2010 GROUP BY T1.tag ORDER BY T2.totalsnatched DESC LIMIT 10
SELECT "T1"."tag" FROM "torrents" "T2" JOIN "tags" "T1" ON "T1"."id" = "T2"."id" WHERE "T2"."groupyear" >= 2010 GROUP BY "T1"."tag" ORDER BY "T2"."totalsnatched" DESC FETCH FIRST 10 ROWS ONLY