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

None of These
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;
SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the temperature in increasing order of all cities

SELECT city FROM weather ORDER BY temperature;
SELECT city, temperature FROM weather;
SELECT city, temperature FROM weather ORDER BY city;
SELECT city, temperature FROM weather ORDER BY temperature;

ANSWER DOWNLOAD EXAMIANS APP