SELECT CLASS FROM captain GROUP BY CLASS HAVING count(*)  >  2
Which classes have more than two captains?
SELECT CLASS FROM captain GROUP BY CLASS HAVING count ( * ) > 2
select class from captain group by class having count ( * ) > value
Which classes have more than two captains ?