Your superior was already hihgly pleased with your previous analysis on NPL (nonperforming loans). Finally, she would li
Posted: Thu Jul 14, 2022 2:11 pm
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.
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 ).
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 (214.28 KiB) Viewed 35 times