Create a select statement that selects the first 10 rows

Reference no: EM133693171

Assessment Type: Practical SQL Coding and Report

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.
Submit your query script file (.sql) with all your queries using the SQL link within the assessment time limit of 2 hours.

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

Assessment Instructions
Follow the instructions to create the lendingclub table and populate it with data from the lending_club_loans_10K.csv file. You will be shown how to access the from the lending_club_loans_10K.csv before the assessment.

Section #1: Server Connection and Simple SQL Queries

Part 1: Updating the table to add a column
Update the table to add a column called recoveries using the given query

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
Write and execute a query that displays all the loan details and order it by funded amounts in Ascending order
Modify the SQL statement to show the number customers(count) 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.
For example, 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?
NOTE: The count should include both Late and Defaulted loan statuses
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: EM133693171

Questions Cloud

Approaching to become an influencer for the organisation : Digital Marketing Officer in charge of picking a social media influencer to lead an extensive campaign as the face of your organisation

Describe collaboration approaches from the literature : Describe collaboration approaches from literature that could facilitate establishing or improving an interdisciplinary team to address an organizational issue.

Developmental theories are also important in helping nurses : Developmental theories are also important in helping nurses assess and treat a person's response to an illness.

Who has an elevated risk of CVD : Contrast two 45 year old men, one who has a low risk of CVD and the other who has an elevated risk of CVD.

Create a select statement that selects the first 10 rows : How many customers defaulted on their loan obligations and Display each Loan Grade and the count of the number of loans related to it

Mechanism of action of these medications : Briefly outline the mechanism of action of these medications. Will these two medications impact exercise in any way?

How we can analyze social media must be used carefully : It allows us to enlarge our scope of vision. How we can analyze social media must be used carefully and focused on improving health care in the world.

Health policy memo on relevant health policy : Write a Health Policy Memo on a relevant health policy topic. Think of writing a memo to your representative in Congress or someone in a policy-making position

In what ways can aprns utilize telemedicine platforms : In what ways can APRNs utilize telemedicine platforms and remote monitoring technologies to remotely access patients' medication adherence.

Reviews

len3693171

5/13/2024 10:27:51 PM

Hi let me know if you can do this one for me . I just need last 3 bullet points in section 3. Only for section 3? The pictures the query the CSV file all I will give you I just need the power bi part with explanation. You can add screenshot in word file as well this is the data please create the powerbi graph using this data. as per asked question in section 3.

Write a Review

Required(*) Message

User Account

All Pages