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