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

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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following query finds colors of boats reserved by "Dustin"?

SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid AND r.bid = b.bid;
SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid
SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid
SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid

ANSWER DOWNLOAD EXAMIANS APP