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