Question: SQL> select * from borrower; CUSTOMER_NAME LOAN_NUMBER --------------- --------------- Adams L-16 Curry L-93 Hayes L-15 Jackson L-14 Jones L-17 McBride L-20 Smith L-11 Smith L-21
SQL> select * from borrower; CUSTOMER_NAME LOAN_NUMBER --------------- --------------- Adams L-16 Curry L-93 Hayes L-15 Jackson L-14 Jones L-17 McBride L-20 Smith L-11 Smith L-21 Smith L-23 Williams L-17 10 rows selected. SQL> select * from depositor; CUSTOMER_NAME ACCOUNT_NUMBER --------------- --------------- Hayes A-101 Hayes A-102 Johnson A-101 Johnson A-201 Johnson A-444 Jones A-217 Lindsay A-222 Majeris A-333 Smith A-215 Smith A-444 Turner A-305 11 rows selected.
Question: What is the output of this SQL statement: SELECT DISTINCT customer_name FROM borrower INTERSECT SELECT customer_name FROM depositor;
A. CUSTOMER_NAME --------------- Jones Hayes Smith Smith Smith
B. None; The SQL statement produces error.
C. CUSTOMER_NAME --------------- Jones Hayes Smith
D. CUSTOMER_NAME
--------------- Adams Curry Jackson McBride Williams
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
