Question

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')
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

Answer 1

______✨ HEY MATE ✨_____

➡️ Option (b) is the right answer ✔️

✌✌Hope it's help u ✌✌

Answer 2

Hello mate

here's your answer

¤¤¤¤¤¤¤¤¤¤¤¤¤¤

Option B✔✔

¤¤¤¤¤¤¤¤¤¤¤¤¤¤

Hope it helps you