Which of the following query finds the total rating of the sailors who have reserved boat "103"?

Question

TuteeHUB · Accepted Answer

NA

TuteeHUB · Answer

SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103;

TuteeHUB · Answer

SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

TuteeHUB · Answer

SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

TuteeHUB · Answer

SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

1.	Which of the following query finds the total rating of the sailors who have reserved boat "103"?
A.	SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103;
B.	SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
C.	SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
D.	SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
Answer» E.

Discussion