Low-carbon electricity share, 2019, largest economies
SDG and SQL country analysis
How do the world’s 20 largest economies perform on five UN Sustainable Development Goals (3, 7, 8, 10 and 13)? I answered this with 9 SQL queries in PostgreSQL, then extended the analysis to every country in the datasets and grouped them into four sustainability profiles: encouraging signs, in transition, critical and at risk.
- PostgreSQL
- CTEs
- Window functions
- Materialized views
- Excel
- Data visualization