Question 11

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:

  • Download Maths Shortcuts PDF
  • Get 300+ previous papers with solutions PDF
  • 500+ Online Tests for Free

cracku

Boost your Prep!

Download App