Question: Which SQL statement(s) will produce same result? a. SELECT DISTINCT customer_name FROM borrower MINUS SELECT customer_name FROM depositor; and SELECT DISTINCT customer_name FROM borrower WHERE

Which SQL statement(s) will produce same result?

a.
SELECT DISTINCT customer_name FROM borrower MINUS SELECT customer_name FROM depositor; and SELECT DISTINCT customer_name FROM borrower WHERE customer_name NOT IN (SELECT customer_name FROM depositor);

b.
SELECT DISTINCT customer_name FROM borrower WHERE customer_name IN (SELECT customer_name FROM depositor); and SELECT DISTINCT customer_name FROM borrower INTERSECT SELECT customer_name FROM depositor;

c.
SELECT DISTINCT customer_name FROM borrower WHERE customer_name IN (SELECT customer_name FROM depositor); and SELECT DISTINCT customer_name FROM borrower WHERE customer_name NOT IN (SELECT customer_name FROM depositor)

d.

SELECT DISTINCT customer_name FROM borrower MINUS SELECT customer_name FROM depositor; and SELECT DISTINCT customer_name FROM borrower INTERSECT SELECT customer_name FROM depositor;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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!

Q:

Given: 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...

Q:

Given: 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...

Q:

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

Q:

Try the following queries. (To execute, highlight the query then hit or click the green triangle.) select * from loan; select * from loan where branch_name = 'Perryridge' and amount > 1200; select...

Q:

Which statement below is the best answer to serve the purpose of an UNION operation? SELECT customer_name FROM borrower UNION SELECT customer_name FROM depositor; SELECT customer_name FROM borrower...

Q:

SQL Query Question. Use the PVFC database if you have it. These are my notes: RETRIEVE ALL COLUMNS AND ROWS select * from product_t select * from employee_t select * from order_t RETRIEVE INDIVIDUAL...

Q:

Need help with problems 11-15 Note: This assignment is in continuation with assignment-03. Use the schema and data from assignment-03 (not 04) to complete the following tasks. Assignment 3 below:...

Q:

Problem 3 (Parts a-b are 3 points each, c-fare 4 points each; 22 points total) Here are some more challenging problems to try against the banking database. a) Generate a list of all cities that...

Q:

Problem 2 (Part a is 2 points, parts b-c are 3 points each; total is 8 points) Write SQL statements that define the following views. Make sure that all columns in each view's results have meaningful...

Q:

Write a SQL query for: Display customers that have neither loan nor account. create table account (account_number varchar(15) not null, branch_name varchar(15) not null, balance number not null,...

Q:

Use the file winter.dat for this exercise. The data were first discussed in Exercise 19 of Chapter 3. a. Test the null hypothesis that class is not associated with breakaga. In the context of Section...

Q:

Predict what will happen to aggregate output and the price level if the Federal Reserve increases the money supply at the same time that Congress implements and income tax cut.

Q:

Explain when an item of income is taxable under both the cash and accrual methods of accounting.

Q:

Journalize the following redemption transactions: 1. Oolong Corporation retired $130,000 face value bonds on June 30, 2017, at 103. The carrying value of the bonds at the redemption date was...