Database table by name Loan_Records is given below.
|
Borrower |
Bank Manager |
Loan Amount |
|
Ramesh |
Sunderajan |
10000.00 |
|
Suresh |
Ramgopal |
5000.00 |
|
Mahesh |
Sunderajan |
7000.00 |
What is the output of the following SQL query?
SELECT count(*)
FROM(
(SELECT Borrower, Bank_Manager FROM Loan_Records) AS S
NATURAL JOIN
(SELECT Bank_Manager, Loan_Amount FROM Loan_Records) AS T
);
1
3
2
9
3
5
4
6