SELECT Nationality FROM ship GROUP BY Nationality HAVING COUNT(*)  >  2
What are the nations that have more than two ships?
SELECT Nationality FROM ship GROUP BY Nationality HAVING COUNT ( * ) > 2
select nationality from ship group by nationality having count ( * ) > value
What are the nations that have more than two ships ?