Which of the following query finds the names of the sailors who have reserved at least one boat?

Question

TuteeHUB · Accepted Answer

SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

TuteeHUB · Answer

SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

TuteeHUB · Answer

SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;

TuteeHUB · Answer

None of These

1.	Which of the following query finds the names of the sailors who have reserved at least one boat?
A.	SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;
B.	SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;
C.	SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;
D.	None of These
Answer» B. SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

Discussion