Q:

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

mhmadesk

Save to bookmark

|

2022-07-08

|

547

Medium

0

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

SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103;
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
SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

Database, MCQ Questions, Database MCQ-questions,

login and add your own answer to this question

All Answers

mhmadesk

2022-07-08

need an explanation for this answer? contact us directly to get an explanation for this answer

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

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)