Your superior was already hihgly pleased with your previous analysis on NPL (nonperforming loans). Finally, she would li

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

Your superior was already hihgly pleased with your previous analysis on NPL (nonperforming loans). Finally, she would li

Post by answerhappygod »

Your superior was already hihgly pleased with your previousanalysis on NPL (nonperformingloans). Finally, she would like you to display the very same resultas a share ofthe total volume (NPL ratio).
Again, group the data by datum and sort it by datum in ascendingorder.
Hint: You can achieve this by utitlizing a case when statementinstead of filter rating inthe where clause.
Your Superior Was Already Hihgly Pleased With Your Previous Analysis On Npl Nonperforming Loans Finally She Would Li 1
Your Superior Was Already Hihgly Pleased With Your Previous Analysis On Npl Nonperforming Loans Finally She Would Li 1 (214.28 KiB) Viewed 34 times
1. LDR_KDE_BASIS: This table includes information on the customer like age, gender, nationality, etc. 2. LDR_KTO_BASIS : This table stores the information on the accounts itself. This includes the type of product, the outstanding (loan) amount, etc. a Note: An account may have multiple sub-accounts. 3. LDR_KDE_KTO_REL : This table's sole purpose is to establish a relation between account data (LDR_KTO_BASIS ) and customer data (LDR_KDE_BASIS ).
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply