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

what city has more courthouses , aberdeen or greenville ?
SELECT "city" FROM table_204_87 WHERE "city" IN ('aberdeen', 'greenville') GROUP BY "city" ORDER BY COUNT("courthouse") DESC LIMIT 1
SELECT "city" FROM "table_204_87" WHERE "city" IN ('aberdeen', 'greenville') GROUP BY "city" ORDER BY COUNT("courthouse") DESC FETCH FIRST 1 ROWS ONLY