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

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

ANSWER DOWNLOAD EXAMIANS APP

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

ANSWER DOWNLOAD EXAMIANS APP