OluwapelumiOlayanju/Water-Supply-and-Sanitation-in-Africa-

# Water Supply and Sanitation in Africa ## Overview This project explores access to clean water and sanitation across African communities using SQL for data analysis. It aims to provide actionable insights to help governments, NGOs, and stakeholders improve public health and infrastructure. ## Problem Statement Millions of Africans face limited access to safe drinking water and adequate sanitation, contributing to the spread of diseases and slowing development. Data gaps and poor analysis have hampered effective interventions. ## Objectives Leverage SQL queries to analyze water and sanitation data, answer key business questions, and identify patterns that can guide strategic decisions. ## Tools Used SQL Word/MS Office – Documentation ## Key Business Questions ### Calculated average water availability per country (~53–58 liters per capita/day). Query: Result: ### Identified communities with non-functional water points, highlighting urgent repair needs. Query: Result: ### Retrieved the top 5 communities with the highest sanitation maintenance costs, flagging potential inefficiencies. Query: Result: ### Computed the total number of functional vs non-functional water points per country. Query: Result: ### Detected 665 high-risk communities with >20% waterborne disease incidence. Query: Result: ### Measured the average distance to water sources per region, typically ~5km. Query: Result: ### Listed communities with both government and NGO support (478 in total). Query: Result: ### Identified the most populated community per country to support resource planning. Query: Result: ## Recommendations: Repair and expand water point infrastructure. Prioritize disease-prone and underserved communities. Support maintenance training for local teams. Leverage data for policy-making and resource allocation. Project by Oluwapelumi Olayanju