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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the name of all cities with their temperature, humidity and countries.

SELECT city, temperature, humidity, country FROM location;
SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;
SELECT weather.city, temperature, humidity, country FROM weather, location;
SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;

ANSWER DOWNLOAD EXAMIANS APP