← ALL CHALLENGES
CHALLENGE / BEGINNER / READY TO QUERY

How has GDP per capita changed in South-eastern Asia?

Practice joining annual GDP per capita with UN M49 geography and comparing South-eastern Asian trends.

01 / THE QUESTION

Question

How did annual GDP per capita change for ISO-coded countries and areas in the UN M49 South-eastern Asia sub-region? Which series rose or fell over a period you choose?

02 / SOURCE TABLES

Tables to use

03 / RELATIONSHIP

ER diagram

ONE TO MANY RELATIONSHIP
country_geographycountry_iso_alpha3Key fieldun_m49_subregion_name
worldbank_gdp_per_capitacountry_iso_alpha3Join fieldyeargdp_per_capita_current_usd

country_geography.country_iso_alpha3 = worldbank_gdp_per_capita.country_iso_alpha3 · one geography row to many annual GDP rows

04 / ANALYST GUIDE

Guide

Analysis requirements

  • Join the tables on country_iso_alpha3.
  • Filter un_m49_subregion_name to South-eastern Asia. The geography table is a current classification snapshot, not a historical border map.
  • Choose a year range and keep null GDP observations visible or state how they were excluded.
  • Return country_iso_alpha3, a country label, year, and gdp_per_capita_current_usd; use a line chart to compare the series.
  • Describe the comparison without treating nominal current US dollars as inflation-adjusted growth.

Suggested query

Expand suggested query
SQL / STARTER QUERY
SELECT g.country_iso_alpha3, g.country_name_un, w.year,
       w.gdp_per_capita_current_usd
FROM country_geography AS g
JOIN worldbank_gdp_per_capita AS w
  ON g.country_iso_alpha3 = w.country_iso_alpha3
WHERE g.un_m49_subregion_name = 'South-eastern Asia'
ORDER BY g.country_iso_alpha3, w.year;