Baselight
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

Results limited to the first 500 rows.

economydata_yearpopulation
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VIR2023104917
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192
VNM2023100352192

Share link

Anyone who has the link will be able to view this.