Create an sql statement that counts the number of the loans

Assignment Help PL-SQL Programming

Reference no: EM133614576

Data Acquisition and Management

Assessment - Practical SQL Coding

Your Task

You are required to:
Complete each of the SQL queries, both provided and self-constructed.

Take a screenshot of each of the queries and results - copy and paste these into your report.
In your Report, explain and summarise the business insights found from executing the SQL queries and the data visualisations.

Background

The SQL Server contains data on Peer-to-Peer Lending. Connection details will be provided on the day of the assessment.

Assessment Instructions

Section #1: Server Connection and Simple SQL Queries
Part 1: Connection to SQL Server on the Cloud
Follow the instructions and Connect to the Yugabyte SQL Cloud Server.

Part 2: Simple SELECT Query
Create a SELECT statement that selects the first 10 rows for all columns of data.
Take a screenshot of the query and its result and paste that in your report.

Section #2: SQL for Business Insights
Part 1: Loan and Funded Amounts
Execute the SQL script provided for loan amounts. Interpret the results of the query as comment in your query script.
Modify the SQL statement to show the number customers where the funded amount is:
Equal to $10,000 dollars
Less than $10,000 dollars
Greater than $10,000 dollars

Take screenshots of the above queries, its result and paste same in your report for interpretation.

Part 2: Loan Terms
Create an SQL statement that counts the number of the loans based on terms. Take a screenshot of your SQL statement and the corresponding results and paste same in your report.
How many terms (count of loans) are of 36 months? How many are of 60 months? Take screenshots of the query and its result and paste that in your report for interpretation.

Part 3: Interest Rate
Create an SQL statement that answers the following business questions:
What is the average interest rate?
What is the highest interest rate?
What is the lowest interest rate?

Take screenshots of the query and its result and paste that in your report for interpretation.

Part 4: Loan Status
Create an SQL statement that:
Counts the number of loans for each unique loan status.
For each of the unique statuses found above, create an SQL statement that displays the first 100 rows of data.

Take screenshots of the query and its result and paste that in your report for interpretation.

Part 5: Loan Grades
Create and SQL statement that answers the following business questions:
Display each Loan Grade and the count of the number of loans related to it.
Display each loan sub-grade and the count of the number of loans related to it.

Take screenshots of the query and its result and paste that in your report for interpretation.

Part 6: Loan Defaults/Delinquencies
Create an SQL statement that answers the following questions:
How many customers defaulted on their loan obligations?
Take screenshots of the query and its result and paste that in your report for interpretation.

Section #3: SQL and Data Visualization for Business Insights

Part 1: Data Acquisition and Data Visualisations
Create a SELECT statement that returns all rows and columns of data.
Export and save the results of the query as CSV file.
Import the CSV file in either PowerBI or Tableau.
Select the following variables for visualisations:
ID, Member ID, Loan Amount, Funded Amount, Term, Interest Rate, Term, Instalment, Grade, Sub-Grade, Employee Length, Home Ownership, Annual Income, Verification Status, Issue Date, Loan Status, Purpose, Address State, DTI, Earliest Credit Line, Outstanding Principal, Total Payment, Recoveries, Collections, Last Payment Date, Last Payment Amount, and Application Type.
From the data selected, create 3 kinds of unique visualisations, to discover more business insights, and interpret the results. Carefully consider the columns that are used for each kind of visualization.

Additionally, can you identify the kinds of customers that default on their loans?

Reference no: EM133614576

Questions Cloud

Who immediately deposits full amount into checking account : The money supply now is. Then Teresa writes a check for $2,500 to Andrew, who immediately deposits full amount into his checking account at Second Republic Bank

Are personally in favor of imposing tariffs on imported good : Regarding tariffs, from a pure consumer point of view, free international trade allows. Are you personally in favor of imposing tariffs on some imported goods?

How will the textbook describe money and banking : How will the textbook describe money and banking? Based on trends you see today, make a prediction for the future of money.

Which is true about the interest income : A foreign corporation doing business in the U.S. receives interest income from Shruthi, a U.S. citizen and resident. Which is true about the interest income?

Create an sql statement that counts the number of the loans : explain and summarise the business insights found from executing the SQL queries and the data visualisations - Create an SQL statement that counts the number

What are the discounts an example of : Which represents the interests of senior citizens and advocates for policies that benefit them. What are these discounts an example of?

How might an increase in the national debt potentially lead : Explain the logic of this argument. How might an increase in the national debt potentially lead to an increase in inflation in the long-run? Explain.

What is the objection to the economic models claim : what is objection to economic model's claim that businesses' environmental responsibility is to maximize profit within law because this maximize social utility?

What is the marginal revenue product per hour from adding : Suppose that hiring a third worker at the campus coffee shop increases output. What is the marginal revenue product per hour from adding that third worker?

User Account

All Pages