DataCamp
Course Outline

Subquery challenge

100xp

Let's test your understanding of the subqueries with a challenge problem! Use a subquery to get 2015 economic data for countries that do not have

  • gov_form of "Constitutional Monarchy" or
  • 'Republic' in their gov_form.

Here, gov_form stands for the form of the government for each country. Review the different entries for gov_form in the countries table.

Instructions

  • Select the country code, inflation rate, and unemployment rate.
  • Order by inflation rate ascending.
  • Do not use table aliasing in this exercise.
    Take Hint (-30xp)