Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Manga Guide To Databases

Authors: Mana Takahashi, Shoko Azuma, Co Ltd Trend

1st Edition

1593271905, 978-1593271909

More Books

Students also viewed these Databases questions

Question

=+3. How could you extend the campaign creatively?

Answered: 1 week ago