Consider the following queries:
Query 1:
SELECT R.sid
FROM Boats B, Reserves R
WHERE B.bid=R.bid AND B.color'red' 
Query2:
SELECT R.sid FROM Reserves R EXCEPT SELECT R.sid
FROM Boats B, Reserves R WHERE B.bid=R.bid AND B.color='red'
What are the results of query 1 and query2 in part A, considering the following instances of Sailors and Reserves tables? 
 

Transcribed Image Text:

SID BID 1 1 3 3 3 101 101 104 10-OCT-19 10-JUL-19 102 DAY 103 10-OCT-17 10-OCT-18 07-NOV-17 BID BNAME 103 COLOR 101 Interlake blue 102 Interlake red Clipper 104 Marine green red SID BID 1 1 3 3 3 101 101 104 10-OCT-19 10-JUL-19 102 DAY 103 10-OCT-17 10-OCT-18 07-NOV-17 BID BNAME 103 COLOR 101 Interlake blue 102 Interlake red Clipper 104 Marine green red

Answer rating: 100% (QA)

QA The operator is used for NOT EQUAL TO operator while the opera... View the full answer