SELECT Nationality FROM ship GROUP BY Nationality HAVING COUNT(*)  >  2
List 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
List the nations that have more than two ships .