1SELECT 
2    year,
3    MAX(CASE WHEN economy = 'CHN' THEN value END) as China,
4    MAX(CASE WHEN economy = 'IND' THEN value END) as India,
5    MAX(CASE WHEN economy = 'VNM' THEN value END) as Vietnam,
6    MAX(CASE WHEN economy = 'IDN' THEN value END) as Indonesia,
7    MAX(CASE WHEN economy = 'KOR' THEN value END) as South_Korea,
8    MAX(CASE WHEN economy = 'SGP' THEN value END) as Singapore,
9    MAX(CASE WHEN economy = 'USA' THEN value END) as USA,
10    MAX(CASE WHEN economy = 'JPN' THEN value END) as Japan,
11    MAX(CASE WHEN economy = 'DEU' THEN value END) as Germany,
12    MAX(CASE WHEN economy = 'BRA' THEN value END) as Brazil,
13    MAX(CASE WHEN economy = 'PHL' THEN value END) as Philippines,
14    MAX(CASE WHEN economy = 'THA' THEN value END) as Thailand,
15    MAX(CASE WHEN economy = 'MYS' THEN value END) as Malaysia
16FROM "@worldbank.world_development_indicators.ny_gdp_mktp_kd_zg"
17WHERE year >= 2000 
18    AND economy IN ('CHN', 'IND', 'VNM', 'IDN', 'KOR', 'SGP', 'USA', 'JPN', 'DEU', 'BRA', 'PHL', 'THA', 'MYS')
19    AND value IS NOT NULL
20GROUP BY year
21ORDER BY year