1-- Trade openness and economic growth relationship
2SELECT 
3    g.economy,
4    g.year,
5    g.value as gdp_growth_rate,
6    trade.value as trade_pct_gdp,
7    exports.value as exports_pct_gdp,
8    imports.value as imports_pct_gdp,
9    gdp_current.value as gdp_current_usd
10FROM "@worldbank.world_development_indicators.ny_gdp_mktp_kd_zg" g
11LEFT JOIN "@worldbank.world_development_indicators.ne_trd_gnfs_zs" trade 
12    ON g.economy = trade.economy AND g.year = trade.year
13LEFT JOIN "@worldbank.world_development_indicators.ne_exp_gnfs_zs" exports 
14    ON g.economy = exports.economy AND g.year = exports.year
15LEFT JOIN "@worldbank.world_development_indicators.ne_imp_gnfs_zs" imports 
16    ON g.economy = imports.economy AND g.year = imports.year
17LEFT JOIN "@worldbank.world_development_indicators.ny_gdp_mktp_cd" gdp_current 
18    ON g.economy = gdp_current.economy AND g.year = gdp_current.year
19WHERE g.year >= 2010
20    AND g.economy IN ('CHN', 'IND', 'VNM', 'IDN', 'SGP', 'KOR', 'USA', 'DEU', 'JPN', 'MYS', 'THA')
21    AND g.value IS NOT NULL
22    AND trade.value IS NOT NULL
23ORDER BY g.economy, g.year