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;
SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
c) SELECT COUNT(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 all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79

SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79
SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)
SELECT * FROM weather WHERE humidity IN (63 to 79)
SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

ANSWER DOWNLOAD EXAMIANS APP