Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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?
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 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
Step: 1
QA The operator is used for NOT EQUAL TO operator while the opera...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started