Find the age of the youngest sailor with age 18, for each rating with at least 2 such sailors

• Only S.rating and S.age are mentioned in the SELECT, GROUP BY or HAVING clauses; other attributes `unnecessary’.

• 2nd column of result is unnamed. (Use AS to name it.)

SELECT S.rating, MIN (S.age)

FROM Sailors S

WHERE S.age >= 18

GROUP BY S.rating

HAVING COUNT (*) > 1

Answer relation

Previous slide

Next slide

Back to first slide

View graphic version