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')
Select the correct option to test your answer:
Correct Answer: Option A (Find the sailor IDs of all sailors who have reserved red boats but not green boats)