Find the age of the youngest sailor with age > 18, for each rating with at least 2 sailors (of any age)

• Shows HAVING clause can also contain a subquery.

• Compare this with the query where we considered only ratings with 2 sailors over 18!

• What if HAVING clause is replaced by:

  • HAVING COUNT(*) ɭ

SELECT S.rating, MIN (S.age)

FROM Sailors S

WHERE S.age > 18

GROUP BY S.rating

HAVING 1 < (SELECT COUNT (*)

FROM Sailors S2

WHERE S.rating=S2.rating)

Previous slide

Next slide

Back to first slide

View graphic version