Analyzing International Debt Statistics

The second project I completed was titled ‘Analyze International Debt Statistics'. This one wasn't too bad but was definitely a bit harder than the first project. I got caught up on the third question (2nd screenshot below). What I realized was I was trying to call the wrong column so I was getting an output but that output returned...nothing. So, once I kept getting that I would try other things and nothing was working. Once I used a hint and realized I just needed to double check the column name I was trying to call, it got a lot easier. I was calling 'indicator_name' and not 'indicator_code' which is what I needed to call. Anyways, work below:

Questions that I needed to answer: 

• What is the number of distinct countries present in the database?

• What country has the highest amount of debt?

• What country has the lowest amount of repayments?