Introduction to SQL
Which of the following query finds the total rating of the sailors who have reserved boat "103"?

SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103;
c) SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

ANSWER DOWNLOAD EXAMIANS APP

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

SELECT weather.city, temperature, humidity, country FROM weather, location;
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 WHERE weather.city = location.city;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
If a query involves NOT, AND, OR with no parenthesis

NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.
AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.
The order of occurrence determines the order of evaluation.
NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.

ANSWER DOWNLOAD EXAMIANS APP