danimilani/debt_SQL

Project in SQL to to analyze international debt data collected by The World Bank. DataCamp guided project.

SQL PROJECT - THE WORLD'S BANK INTERNATIONAL DEBT DATA

Project in SQL to to analyze international debt data collected by The World Bank.

Scope:

1. Look at the first ten rows of the international_debt table.

SQL Query:

Result:

2. Check and extract the number of unique countries present in the table.

SQL Query:

Result:

3. Check what are the debt indicators in this database using DISTINCT.

SQL Query:

Result:

4. Find out the total amount of debt (in USD) that is owed by the countries.

SQL Query:

Result:

5. Check what is the country that has the highest debt amount.

SQL Query:

Result:

6. Find out on an average how much debt the countries owe and the top 10 indicators (higher amounts of debt).

SQL Query:

Result:

7. Find out which country owes the highest amount of Long Term Debts - Category DT.AMT.DLXF.CD

SQL Query:

Result:

8. Find out what is the most common indicator in which the countries owe their debt.

SQL Query:

Result:

9. Find out the maximum amount of debt that each country has.

SQL Query:

Result: