ISRO Scientist or Engineer Computer Science Dec 2017 Question 11

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


Register with


Boost your Prep!

Download App