1-- FDI inflows and relationship with growth
2SELECT 
3    g.economy,
4    g.year,
5    g.value as gdp_growth_rate,
6    fdi.value as fdi_inflow_pct_gdp,
7    fdi_net.value as fdi_net_inflows_usd,
8    gdp_current.value as gdp_current_usd,
9    (fdi_net.value / gdp_current.value * 100) as fdi_pct_gdp_calculated
10FROM "@worldbank.world_development_indicators.ny_gdp_mktp_kd_zg" g
11LEFT JOIN "@worldbank.world_development_indicators.bx_klt_dinv_wd_gd_zs" fdi 
12    ON g.economy = fdi.economy AND g.year = fdi.year
13LEFT JOIN "@worldbank.world_development_indicators.bx_klt_dinv_cd_wd" fdi_net 
14    ON g.economy = fdi_net.economy AND g.year = fdi_net.year
15LEFT JOIN "@worldbank.world_development_indicators.ny_gdp_mktp_cd" gdp_current 
16    ON g.economy = gdp_current.economy AND g.year = gdp_current.year
17WHERE g.year >= 2010
18    AND g.economy IN ('CHN', 'IND', 'VNM', 'IDN', 'SGP', 'THA', 'MYS', 'PHL', 'USA', 'BRA')
19    AND g.value IS NOT NULL
20    AND fdi.value IS NOT NULL
21ORDER BY g.economy, g.year