SELECT nationality ,  count(*) FROM swimmer GROUP BY nationality HAVING count(*)  >  1
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 ( * ) > value
List countries that have more than one swimmer .