(Data sourced from BudgIT via Wikipedia)

🧠 Project Summary

This project analyzes Nigeria’s economic distribution by state using 2021 GDP data from BudgIT. I structured the data in MySQL, created relational tables, and wrote queries to explore GDP trends, both by state and by geopolitical zone, using the JOIN operation.

🛠 Tools Used

• MySQL
• SQL (JOIN, GROUP BY, ORDER BY, WHERE)
• Data manually extracted from BudgIT (via Wikipedia)

🗃️ Tables Created

• state_gdp — GDP per state in trillions (₦), billions (USD), and per capita (USD)
• state_zone — Mapping of each state to one of Nigeria’s 6 geopolitical zones

📊 Key Queries & Insights

📌 Query 1: Top 5 States by Total GDP:

💡 Insight: Lagos dominates as Nigeria’s economic hub.