7. The highest amount of principal repayments

/* We can see that the indicator DT.AMT.DLXF.CD tops the chart of average debt. This category includes repayment of long term debts. 
Countries take on long-term debt to acquire immediate capital. More information about this category can be found here.

An interesting observation in the above finding is that there is a huge difference in the amounts of the indicators after the second one. 
This indicates that the first two indicators might be the most severe categories in which the countries owe their debts.

We can investigate this a bit more so as to find out which country owes the highest amount of debt in the category of long term debts (DT.AMT.DLXF.CD). 
Since not all the countries suffer from the same kind of economic disturbances, 
this finding will allow us to understand that particular country's economic condition a bit more specifically. */



select country_name, round(avg(debt)/1000000,2) as average_debt, indicator_name,
indicator_code
from international_debt
group by country_name, indicator_name, indicator_code
having indicator_code = 'DT.AMT.DLXF.CD'
order by average_debt desc
limit 10;