← ALL CHALLENGES
CHALLENGE / BEGINNER / READY TO QUERY

Must high human development mean high CO₂ emissions?

Practice joining HDI with per-person CO₂ emissions by country and year, then inspect the exceptions.

01 / THE QUESTION

Question

Do countries with higher Human Development Index values always emit more CO₂ per person? Which countries combine relatively high HDI with lower emissions?

02 / SOURCE TABLES

Tables to use

03 / RELATIONSHIP

ER diagram

ONE TO ONE RELATIONSHIP
undp_human_development_indexcountry_iso_alpha3Key fieldyearKey fieldhuman_development_index
worldbank_co2_emissions_per_capitacountry_iso_alpha3Join fieldyearJoin fieldco2_emissions_tco2e_per_capita

undp_human_development_index.country_iso_alpha3 = worldbank_co2_emissions_per_capita.country_iso_alpha3 + year · one HDI observation to one CO₂ observation for each country and year

04 / ANALYST GUIDE

Guide

Analysis requirements

  • Join undp_human_development_index and worldbank_co2_emissions_per_capita on both country_iso_alpha3 and year.
  • Start with each country's latest year with non-null observations in both datasets. Retain year, since that year may differ between countries; filter to one common year before drawing a same-year comparison.
  • Plot human_development_index against co2_emissions_tco2e_per_capita and inspect exceptions to the overall pattern.
  • The CO₂ measure excludes land use, land-use change and forestry (LULUCF), uses EDGAR estimates and is not the archived World Bank CO₂ series. HDI combines health, education and living standards; association does not prove causation.

Suggested query

Expand suggested query
SQL / STARTER QUERY
WITH paired AS (
  SELECT h.country_iso_alpha3, h.country_name, h.year,
         h.human_development_index, e.co2_emissions_tco2e_per_capita,
         ROW_NUMBER() OVER (PARTITION BY h.country_iso_alpha3 ORDER BY h.year DESC) AS recency
  FROM undp_human_development_index AS h
  JOIN worldbank_co2_emissions_per_capita AS e
    ON h.country_iso_alpha3 = e.country_iso_alpha3
   AND h.year = e.year
  WHERE h.human_development_index IS NOT NULL
    AND e.co2_emissions_tco2e_per_capita IS NOT NULL
)
SELECT country_iso_alpha3, country_name, year,
       human_development_index, co2_emissions_tco2e_per_capita
FROM paired
WHERE recency = 1
ORDER BY human_development_index DESC;