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

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" AS "cte"