Introduction to SQL
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

NOT IN only.
LIKE only.
IN only.
Both IN and NOT IN.

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, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid
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, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid

ANSWER DOWNLOAD EXAMIANS APP