How many swimmers are there in record?
select count(*) from swimmer
What about in terms of nationality?
select nationality, count(*) from swimmer group by nationality
Show me the countries with more than one.
select nationality, count(*) from swimmer group by nationality having count(*) > 1