Consider the schema
Sailors(sid, sname, rating, age) with the following data
For the query
SELECT S.rating, AVG(S.age) AS avgage FROM Sailors S
Where S.age $$\ge$$ 18
GROUP BY S.rating
HAVING 1 $$<$$ (SELECT COUNT($$*$$) FROM Sailors S2 where S.rating $$=$$ S2.rating)
The number of rows returned is
Create a FREE account and get: