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)

Who or which group is most popular in 2015?
SELECT artist FROM torrents WHERE groupyear = 2015 GROUP BY artist ORDER BY totalsnatched DESC LIMIT 1
SELECT "artist" FROM "torrents" WHERE "groupyear" = 2015 GROUP BY "artist" ORDER BY "totalsnatched" DESC FETCH FIRST 1 ROWS ONLY