World Bank Analysis Using SQL

World Bank Analysis Using SQL

By: Jordan Temple

Data comes in all different formats and sizes. Sometimes Excel won't get the job done due to the size of the data set, so you have to use a program that is specifically for large data sets. In this instance, SQL (Structured Query Language) is the program I used due to the size of the data set for the project.

The International Development Association (IDA) is an arm of The World Bank whose focus is on lending and granting funds to assist developing nations in just that, developing their countries. The data for this project comes from The World Bank website and can be found here.

Questions To Be Answered:

There are four questions I plan to answer by using the provided data set.

1. What are the 5 largest transactions from Nicaragua?
2. How many transactions did Nicaragua perform?
3. What is the average amount paid back to the bank by Nicaragua?
4. What is the maximum amount owed back to the IDA?

Question 1 - What are the 5 largest transactions from Nicaragua?

In order to answer the first question, I ran the below query.

By running this query, I was given the below output that provided the answer to my first question.

As you can see in the above photo, the top 5 transactions from Nicaragua are:

1. Nicaragua COVID-19 Response - $116,000,000.
2. ECON.REC.CR. - $110,000,000.
3. Hurricanes Eta and Iota ERP - $80,000,000
4. NI-Hurricanes Eta and Iota ERP - $80,000,000.
5. NI FINAN. SEC.ADJUSTMENT - $70,000,000.

Question 2 - How many transactions did Nicaragua perform?

In order to answer my second question, I ran the below query which searched for the total number of transactions by Nicaragua in the data set.

By running this query, I was given the below output that provided the answer to my second question.

As you can see at the top of the above photo, there were 13,922 transactions performed by Nicaragua.

Question 3 - What is the average amount paid back to the bank by Nicaragua?

In order to answer my third question, I ran the below query which searched for the average amount paid back to the bank by Nicaragua in the data set.

By running this query, I was given the below output that provided the answer to my third question.

Nicaragua paid an average total of $10,628,679.54 back to the banks.

Question 4 - What is the maximum amount owed back to the IDA?

In order to answer my fourth question, I ran the below query which searched for the maximum amount owed back to the bank in the data set.

By running this query, I was given the below output that provided the answer to my fourth question.

The total amount paid back to the IDA was $793,256,127.64.

Insights:

To conclude my findings, it was determined that Nicaragua's most lucrative spending was $116,000,000 for COVID-19 Pandemic relief. The country as a whole had just shy of 14,000 transactions, coming in at 13,922. On average, Nicaragua is having to pay back north of $10.5 million dollars. The max balance owed by a country to the IDA is $793,256,127.64.

Thanks for checking out my project - I hope you enjoyed it!