CREATE TABLE swimmer (nationality VARCHAR)

List countries that have more than one swimmer.
SELECT nationality, COUNT(*) FROM swimmer GROUP BY nationality HAVING COUNT(*) > 1
SELECT "nationality", COUNT(*) FROM "swimmer" GROUP BY "nationality" HAVING COUNT(*) > 1