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 same release titles are there in the table?
SELECT COUNT(*) FROM (SELECT groupname FROM torrents GROUP BY groupname HAVING COUNT(*) > 1)
WITH "cte" AS (SELECT 1 AS "_" FROM "torrents" GROUP BY "groupname" HAVING COUNT(*) > 1) SELECT COUNT(*) FROM "cte" "cte"