Average life expectancy (years)
World Life Expectancy — SQL Analysis
- Question
- How has life expectancy changed across 193 countries between 2007 and 2022, and which factors is it linked to?
- What I did
- Cleaned 2,941 rows in MySQL — removed 3 duplicate records, filled 8 missing status labels and estimated 2 missing values — then answered seven questions with SQL.
- What I found
- The global average rose from 66.8 to 71.6 years, with a dip in 2020. Developed countries averaged 79.2 years against 66.8 for developing countries.