Database-Management-System
August 28, 2024K-Map
August 28, 2024Database-Management-System
Question 855 |
Consider the schema
Sailors(sid, sname, rating, age) with the following data
For the query
SELECT S.rating, AVG(S.age) AS average FROM Sailors S
Where S.age >= 18
GROUP BY S.rating
HAVING 1 < (SELECT COUNT(*) FROM Sailors S2 where S.rating = S2.rating)
The number of rows returned is
Sailors(sid, sname, rating, age) with the following data
For the query
SELECT S.rating, AVG(S.age) AS average FROM Sailors S
Where S.age >= 18
GROUP BY S.rating
HAVING 1 < (SELECT COUNT(*) FROM Sailors S2 where S.rating = S2.rating)
The number of rows returned is
6 | |
5 | |
4 | |
3 |
Question 855 Explanation:
Correct Answer: D
Question 855 Explanation:
Subscribe
Login
0 Comments