Emmapluz/nigeria-health-sql-analysis

SQL analysis of Nigeria health indicators using WHO 2020 data — Microsoft SQL Server # Nigeria Health Indicators — SQL Analysis ### Microsoft SQL Server queries on WHO World ### Health Statistics 2020 data **Analyst:** Nwankwo Emmanuel **Tools:** Microsoft SQL Server · SSMS · SQL **Data Source:** WHO World Health Statistics 2020 via Kaggle **GitHub:** github.com **Portfolio:** View Portfolio --- ## Project Overview This project analyses four key Nigeria health indicators using SQL queries on WHO World Health Statistics 2020 data imported into Microsoft SQL Server. It is a follow-up to my Python EDA project on the same dataset — demonstrating the same data analysed using a completely different tool. The four datasets imported into SQL Server: - Life Expectancy at Birth - Infant Mortality Rate - Maternal Mortality Ratio - Malaria Incidence --- ## Queries Built **Query 1 — Nigeria Life Expectancy Trend** SELECT with WHERE and ORDER BY showing Nigeria's life expectancy from 2000 to 2019. **Query 2 — Top 10 Countries by Life Expectancy** TOP N with ORDER BY showing global leaders in life expectancy in 2019. **Query 3 — Nigeria vs African Countries** CASE statement with subquery comparing Nigeria to nine other African countries against the global average. **Query 4 — Maternal Mortality Classification** CASE statement classifying Nigeria's maternal mortality severity level for each year from 2000 to 2017. **Query 5 — Malaria Burden Comparison** Subquery with CASE comparing malaria incidence across ten African countries in 2018. **Query 6 — Nigeria Complete Health Profile** UNION ALL across four tables showing Nigeria's latest available value for all four indicators in a single query result. --- ## Key Findings | Indicator | Value | Year | Global Context | |---|---|---|---| | Life Expectancy | 62.62 years | 2019 | 22 years below Japan (84.26) | | Infant Mortality | 74.2 per 1,000 | 2019 | ~3x global average | | Maternal Mortality | 917 per 100,000 | 2017 | Critical level | | Malaria Incidence | 291.9 per 1,000 | 2018 | 5th highest i …