Menu
Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

  1. What does the following query find?
    (SELECT DISTINCT r.sid
    FROM boats b, reserves r
    WHERE b.bid = r.bid
    AND b.color = 'red')
    MINUS
    (SELECT DISTINCT r.sid
    FROM boats b, reserves r
    WHERE b.bid = r.bid
    AND b.color = 'green')

    2. A.

     Find the sailor IDs of all sailors who have reserved red boats but not green boats
    B.

     Find the sailor IDs of at least one sailor who have reserved red boats but not green boats
    C.

     Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats
    D.

     None of These

    View Answer

    Workspace

    View Answer

    Answer : Option A

    Explanation :

    Explanation Not Provided

Write your comments here:

Be The First To Comment