Introduction to SQL
Find the name of cities with all entries whose temperature is in the range of 71 and 89

SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;
SELECT * FROM weather WHERE temperature NOT IN (71 and 89);
SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;
SELECT * FROM weather WHERE temperature NOT IN (71 to 89);

ANSWER DOWNLOAD EXAMIANS APP

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

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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following query finds colors of boats reserved by "Dustin"?

SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid
SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid
SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid AND r.bid = b.bid;
SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid

ANSWER DOWNLOAD EXAMIANS APP