Answering business questions at SmallBank
(graded individual assignment #3)
GOAL: Learning SQL
TASK: Create an ADS notebook containing the text of the questions listed below and the SQL queries that produce the corresponding answers when run. Post the notebook by the due date in your BOX folder. Filename for the notebook is YourLastname_YourFirstName_SQL2.
Insert the pledge at the top of the notebook.
CRITERIA: SQL must produce the correct answer.
Make sure that all result columns have an easy-to-understand name.
This is a pledged individual assignment. You must work on your own.
BUSINESS QUESTIONS AT SMALLBANK
Q1: Who are Park's clients? (last and first names, alphabetized)
Q2: Who manages the most money?
Q3: What is our loan exposure by city? (no need to split exposure if two customers own the same loan across two cities). Format the
numbers.
Q4: We measure loan officer performance in terms of the amount they manage. Who are our above-average performers, and how much
do they manage? Rank them (either asc or desc).
Q5: How many of Bill Ford’s customers are insured?
Q6: Create a report showing that usually on average we are giving better rates to larger loans. Rates and avg loans with nicely formatted numbers. Order as appropriate.
Q7: We obviously care about interest (= rate x principal). Rank our loan officers in terms of their interest production. Ignore due dates.
Q8: How much interest do we expect to earn in each city? Present both the total $ and a percentage of the total interest per city. The formatting code for percentages is 'p').
Q9: Who are our top three customers in terms of future total interest paid? Show their names and the total interest. Rank them.
Q10: How much interest will we earn in 2023? and in 2024?