Database: swimming
Question: List countries that have more than one swimmer.
SQL:
SELECT nationality ,  count(*) FROM swimmer GROUP BY nationality HAVING count(*)  >  1