p.200
"Find age of the youngest sailor who is eligible to vote, for each rating level with at least two such sailors"
SELECT S.rating, MIN (S.age) AS minage
FROM Sailors S
WHERE S.age >= 18
GROUP BY S.rating
HAVING COUNT (*) > 1
Previous slide
Next slide
Back to first slide
View graphic version