zainabibraheem/Water-Access-Analysis-in-Africa---SQL

The primary goal of this project is to analyse data, identify patterns, and propose informed, data-driven recommendations that governments and stakeholders can implement to effectively improve water access and sanitation in African communities. ## Water Access and Sanitation in Africa: A Case Study ## Project Overview The primary goal of this case study is to analyze data, identify patterns, and propose informed, data-driven recommendations that governments and stakeholders can implement to effectively improve water access and sanitation in African communities. ## Problem Statement Access to clean water and proper sanitation remains a critical challenge in many African communities, affecting public health, economic development, and overall quality of life. Despite efforts from governments and international organizations, millions of people still lack reliable water sources and adequate sanitation facilities. ## Aim and Objectives ## Aim: The aim of this analysis is to analyze data, identify patterns, and propose informed, data-driven recommendations that governments and stakeholders can implement to effectively improve water access and sanitation in African communities. ## Objectives: To provide insights into the availability of water resources in relation to community populations. To assess the level of governmental and NGO intervention in water and sanitation projects across different communities. To provide insights into the satisfaction levels of communities based on water access, sanitation quality, and average distance to the nearest water source in different regions. To explores the distribution of different water sources and their operational status ## Exploratory Data Analysis This was done to answer key business questions. 1. Write an SQL query to calculate the average water availability (liters per capita per day) for each country. 2. Write an SQL query to retrieve details of communities where at least one water point is non-functional. 3. Please retrieve the information for the top five communities with the highest annual sanitation maintenance costs. 4. Calculate the total number of functional and non-functional water points per country 5. Identify commu …