Question discussion

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

307807Medium 1 reply 613 views
2
Which of the following query finds the total rating of the sailors who have reserved boat "103"?
  • ASELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103;
  • BSELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
  • Cc) SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
  • DSELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
Correct answer: D

Discussion 1

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