List countries that have more than one swimmer.
CREATE TABLE swimmer (nationality VARCHAR)
SELECT nationality, COUNT(*) FROM swimmer GROUP BY nationality HAVING COUNT(*) > 1
### Context: CREATE TABLE swimmer (nationality VARCHAR) ### Question: List countries that have more than one swimmer. ### Answer: SELECT nationality, COUNT(*) FROM swimmer GROUP BY nationality HAVING COUNT(*) > 1