Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Why is the loan output blank in this query? SELECT b.branch_id, loan.s LOAN from branch b LEFT OUTER JOIN (SELECT a.open_branch_id, sum(a.avail_balance) s FROM account
Why is the loan output blank in this query?
SELECT b.branch_id, loan.s LOAN
from branch b LEFT OUTER JOIN (SELECT a.open_branch_id, sum(a.avail_balance) s
FROM account a INNER JOIN product p
ON a.product_cd = p.product_cd
WHERE p.product_type_cd='LOAN'
GROUP BY a.open_branch_id) loan
ON b.branch_id = loan.open_branch_id
ORDER BY b.branch_id;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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