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)

how many entries are of each type?
SELECT COUNT(*), releasetype FROM torrents GROUP BY releasetype
SELECT COUNT(*), "releasetype" FROM "torrents" GROUP BY "releasetype"