Question: Given two relation table R and S as follows: R A B C a1 b1 c1 a3 b3 c3 S A B C a1 b1
Given two relation table R and S as follows:
R
| A | B | C |
a1 | b1 | c1 |
a3 | b3 | c3 |
S
| A | B | C |
a1 | b1 | c1 |
a2 | b2 | c2 |
What is the result from the following SQL statement?
SELECT * FROM S
MINUS
SELECT * FROM R
(Here, MINUS is the same as DIFFERENCE in the textbook and lecture notes.)
Group of answer choices
b.
| A | B | C |
a1 | b1 | c1 |
a.
| A | B | C |
a1 | b1 | c1 |
a2 | b2 | c2 |
a3 | b3 | c3 |
d.
| A | B | C |
a2 | b2 | c2 |
c.
| A | B | C |
a3 | b3 | c3 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts

a1
b1
c1
a3
b3
c3
a1
b1
c1
a2
b2
c2
a1
b1
c1
a1
b1
c1
a2
b2
c2
a3
b3
c3
a2
b2
c2
a3
b3
c3