Emmapluz/nigeria-health-sql-analysis
Domaine:
healthcareCréateur:
Emm
Hôte:
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 …