helin-c/population-analysis

A SQL-based analysis of global population trends across continents to support diplomatic trade strategies for the Government of Kenya # Government of Kenya: Global Population & Trade Strategy Analysis ## 🌍 Project Overview This project was completed as an individual SQL technical delivery task. The scenario involves acting as a Data Analyst for the Government of Kenya. The Kenyan government is currently reassessing its trade strategies with various nations and requires an understanding of how the global population is changing across continents to better target their diplomatic efforts. The objective was to write repeatable SQL queries to answer specific demographic questions and provide actionable business insights. ## 🛠️ Tools & Techniques * **SQL Server (T-SQL):** Used for database querying, data manipulation, and extraction from a provided countries database. * **Techniques Used:** `JOIN`s, Aggregate Functions (`SUM`, `AVG`, `COUNT`), Conditional Aggregation (`CASE WHEN`), Filtering (`WHERE`, `IS NOT NULL`), and Sorting (`ORDER BY`). ## 📊 Key Queries & Insights ### 1. African Representation in the Database **Question:** How many entries in the database are from Africa? ```sql SELECT COUNT(continent) AS africa_country_count FROM dbo.countries WHERE continent = 'Africa'; ``` **Insight:** There are 56 entries from Africa in the database. ### 2. Total African Population (2010) **Question:** What was the total population of Africa in 2010? ```sql SELECT SUM(p.population) AS africa_population_2010 FROM dbo.population_years AS p INNER JOIN dbo.countries AS c ON c.id = p.country_id WHERE c.continent = 'Africa' AND p.year = 2010; ``` **Insight:** The total population of Africa in 2010 was 991 million. ### 3. South American Average Population (2000) **Question:** What is the average population of countries in South America in 2000? ```sql SELECT AVG(p.population) AS avg_population_2000 FROM dbo.population_years AS p INNER JOIN dbo.countries AS c ON c.id = p.country_id WHERE c.continent = 'South America' AND p.year = 2000; ``` **Insight:** The average population of South American countries in 2000 …