Analysis of International Development Association (IDA) Credits and Grants using SQL
Overview
The purpose of this project was to practice basic SQL statements and aggregate functions. IDA credits are public and publicly guaranteed debt extended by the World Bank Group. They assist their member countries by helping them meet their development needs through various funding avenues. All amounts are listed in US dollars.
Some insights I gained were:
The total amount due to the IDA is $20,526,620,109,947.17, and the highest amount owed is $793,256,127.64.
Nicaragua has 13,922 separate amounts owed for different projects.
Honduras has 1,444 projects with an interest rate greater than 1.
The Data
The World Bank Group dataset can be found at through the following link:
https://finances.worldbank.org/Loans-and-Credits/IDA-Statement-Of-Credits-and-Grants-Historical-Dat/tdwh-3krx . At the time of this post, it contains approximately 1.13M rows, 30 columns, and each row represents a credit or grant.
I downloaded the data as a CSV file and uploaded it to https://bit.io . This site offers serverless postgres SQL. It was quick and easy to get started with practicing SQL statements and functions.
The Analysis
To begin the analysis, I used the basic SELECT statement to query the database and make sure everything looked like it should.
SELECT
The next statements I practiced were LIMIT, Alias (AS), and WHERE:
LIMIT
AS
WHERE
Then I tried some aggregate functions (COUNT, MAX, SUM, and AVG) and used the GROUP BY and ORDER BY statements:
COUNT
The above COUNT statement was how I determined how many separate projects Nicaragua was paying for.
COUNT and GROUP BY
MAX
Determined that the most someone owes right now is $793,256,127.64.
SUM
Determined the total amount owed to World Bank Group: $20,526,620,109,947.17
AVG
ORDER BY
I finished by practicing the operators AND, OR, and NOT:
AND
Determined how many projects Honduras has over 1% interest.
OR
NOT
Final Thoughts
This project was great practice on a real-world dataset. I was able to determine some interesting information about how much is currently due to the IDA and how many projects different countries have: the total amount due to the IDA was $20,526,620,109,947.17, and the highest amount owed was $793,256,127.64; Nicaragua has 13,922 separate amounts owed for different projects; and Honduras has 1,444 projects with an interest rate greater than 1.
Thank you for reading! Please contact me below or connect with me on LinkedIn with any questions or comments.
Comments