CREATE TABLE table_204_87 (id DECIMAL, "courthouse" TEXT, "city" TEXT, "street address" TEXT, "jurisdiction" TEXT, "dates of use" TEXT, "named for" TEXT)

how many cities have more than one courthouse listed ?
SELECT COUNT(*) FROM (SELECT "city" FROM table_204_87 GROUP BY "city" HAVING COUNT("courthouse") > 1)
WITH "cte" AS (SELECT 1 AS "_" FROM "table_204_87" GROUP BY "city" HAVING COUNT("courthouse") > 1) SELECT COUNT(*) FROM "cte" AS "cte"