You are walking into a presentation with the CEO of the company to explain the r

Question

You are walking into a presentation with the CEO of the company to explain the results from the following query, a key cog in the full business decision-making process. Create the documentation associated with the query and how you would present it. Be sure to include a high-level summary in addition to the technical details Here is an explanation of relevant DB fields: a) loans -A table containing one record for each loan the company considers. This includes loans that the company rejected i. id - Integer - The primary key ii. funding, date-Date-The contractual date on which the customer agreed to receive the ii. amount_cents - Integer - The full issuance amount of the loan in cents. (i.e. $100 is iv. customer_id - Integer - A foreign key matching to the unique customer associated with funds represented as 10000) the loan b) loan_ tasks - A table containing all movements of money relating to a given loan, including issuance, fees, and payments i. id - Integer - The primary key ii. status-String-The status of the loan task. May be created, completed, or canceled iii. type - String - The purpose of the loan task. Each issued loan will have a single task called issue_loan, which represents the funding of the loan eff_date - Date - The date that the money movement the task represents actually happened. iv. v. loan_id - Integer - A foreign key matching the loan associated with the loan task c) credit_decisions- A table containing the credit underwriting decisions. There will be many of these at various stages of the loan to checkpoint a customers eligibility status i. id - Integer - The primary key 11. Customer id-Integer-The foreign key of the customer associated with this credit decision transunion_credit_report id - Integer - A foreign key matching to the credit report used in the decision iii. d) transunion_credit_reports - A table containing the credit reports we have pulled for underwriting i. id - Integer - The primary key ii. fico_score - integer- The FICO score contained in the credit report

Explanation / Answer

The query information is as follows :

The tables shows the output - selects the month with highest loan funding data and effective date with average ficoscore for the given people , and also sum of the people sorted by ascending order of funding and effective date with respect to cents and dollars whose loan status is in created or completed state and can be issued loan (Loan given to last person in the credit decision table) .

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.