Introduction
For this project, I pretend to have been hired as a data analyst to look over all our bank loans and give insight.
I will be using the data set from the World Bank. Note that this data is kept up to date quarterly by the World Bank.
Data
In the images below, I will be providing answers to the following:
Return all of the table
Return all rows of the table, but only the borrower & due to IDA column
Only show the first 5 rows of the previous query
Abbreviate one of the column names so it's easier to write
Show us all transactions from Nicaragua (the country).
How many total transactions?
How many total transactions per country?
What is the maximum owed to the IDA?
Which was the most recent to pay?
Who has the most loans?
I appreciate you taking the time to review my project. It was an enjoyable experience to delve into fundamental SQL skills. As I strive to broaden my expertise in data analytics, I would greatly value any suggestions or feedback you may have.
Comments