Menu
Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

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

    2. 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.

     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

    View Answer

    Workspace

    View Answer

    Answer : Option D

    Explanation :

    Explanation Not Provided

Write your comments here:

Be The First To Comment