1-- Average GDP growth, volatility, and key metrics by country (2014-2024)
2SELECT 
3    g.economy,
4    AVG(g.value) as avg_gdp_growth_10y,
5    STDDEV(g.value) as growth_volatility,
6    MIN(g.value) as min_growth,
7    MAX(g.value) as max_growth,
8    COUNT(*) as data_years,
9    AVG(pc.value) as avg_gdp_per_capita,
10    AVG(fdi.value) as avg_fdi_inflow_pct_gdp,
11    AVG(trade.value) as avg_trade_pct_gdp
12FROM "@worldbank.world_development_indicators.ny_gdp_mktp_kd_zg" g
13LEFT JOIN "@worldbank.world_development_indicators.ny_gdp_pcap_kd" pc 
14    ON g.economy = pc.economy AND g.year = pc.year
15LEFT JOIN "@worldbank.world_development_indicators.bx_klt_dinv_wd_gd_zs" fdi 
16    ON g.economy = fdi.economy AND g.year = fdi.year
17LEFT JOIN "@worldbank.world_development_indicators.ne_trd_gnfs_zs" trade 
18    ON g.economy = trade.economy AND g.year = trade.year
19WHERE g.year >= 2014 AND g.year <= 2024
20    AND g.economy IN ('CHN', 'IND', 'VNM', 'IDN', 'USA', 'DEU', 'JPN', 
21                      'KOR', 'SGP', 'BRA', 'MEX', 'THA', 'MYS', 'PHL')
22    AND g.value IS NOT NULL
23GROUP BY g.economy
24ORDER BY avg_gdp_growth_10y DESC