SELECT "economy", CAST(TRIM(LEADING 'yr' FROM population_t."year") AS INT) "data_year", "population" 
FROM (
  UNPIVOT @worldbank.world_development_indicators.sp_pop_totl
  ON COLUMNS (* EXCLUDE "economy")
  INTO 
    NAME "year" 
    VALUE "population"
) population_t
INNER JOIN @kaggle.joebeachcapital_world_bank_country_profile.worldbank_country_profile
  ON "economy" = "country_code"
WHERE "data_year" > 2000