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)

Which year had the minimum number of releases?
SELECT groupyear FROM torrents GROUP BY groupyear ORDER BY COUNT(groupname) LIMIT 1
SELECT "groupyear" FROM "torrents" GROUP BY "groupyear" ORDER BY COUNT("groupname") FETCH FIRST 1 ROWS ONLY