1SELECT "economy", CAST(TRIM(LEADING 'yr' FROM population_t."year") AS INT) "data_year", "population" 
2FROM (
3  UNPIVOT @worldbank.world_development_indicators.sp_pop_totl
4  ON COLUMNS (* EXCLUDE "economy")
5  INTO 
6    NAME "year" 
7    VALUE "population"
8) population_t
9INNER JOIN @kaggle.joebeachcapital_world_bank_country_profile.worldbank_country_profile
10  ON "economy" = "country_code"
11WHERE "data_year" > 2000