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?
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;