Which of the following queries returns the names of sailors who have reserved at least one boat?
A. SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;
B. SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;
C. SELECT DISTINCTIVE s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;
D. None of These
Answer:C
Which of the following queries returns the names of sailors who have reserved at least one boat?
A. SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; B. SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; C. SELECT DISTINCTIVE s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; D. None of These
Explanation: CHOOSE DISTINCTIVE s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;