Question: 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

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? 
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 

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

Step by Step Solution

3.33 Rating (144 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!