SQL Challenges and Projects

Welcome to the SQL section of my GitHub profile! Here you will find various SQL challenges and projects that demonstrate my expertise in SQL and my ability to handle complex data analysis tasks.

About This Repository

This repository contains a collection of SQL scripts and projects that I have worked on. These projects range from simple query challenges to complex data manipulation and analysis tasks. The goal of this repository is to showcase my SQL skills and provide examples of my work for potential employers and collaborators.

Projects and Challenges

1. World Populations Analysis

Description: This case study focuses on analyzing global population data by continent and country using SQL queries. The aim of this project is to answer questions such as-

• Number of African Countries
• Population of Oceania in 2005
• Average Population of South America in 2003
• Smallest Population in 2007
• Average Population of Countries
• Countries with 'The' in Their Name
• Total Population by Continent in 2010

Dataset:

• The dataset consists of two tables: countries, which contains information about different countries and their respective continents, and population_years, which records the population of each country for various years.
• World Populations Case Study

2. Danny's Diner Case Study

Description: Analyzing customer spending patterns and menu item popularity at Danny's Diner.

Highlights:

• Determined the total amount spent by each customer.
• Identified the most popular items on the menu.
• Evaluated the effectiveness of the customer loyalty program.
• Danny's Diner Case Study

3. Davie's Burgers Analysis

Description: Investigating customer order patterns and special instructions at Davie's Burgers.

Highlights:

• Extracted and analyzed special instructions left by customers.
• Identified common themes and keywords in special instructions.
• Provided recommendations for improving customer satisfaction based on the analysis.
• Davies Burger Case Study

4. International Debt Statistics: Analyzing International Debt Data

Description: This project focuses on analyzing international debt data collected by The World Bank. The dataset contains information about the amount of debt (in USD) owed by developing countries across several categories. The goal of this analysis is to find answers to various questions, such as:

• What is the total amount of debt owed by the countries listed in the dataset?
• Which country owns the maximum amount of debt, and what does that amount look like?
• What is the average amount of debt owed by countries across different debt indicators?

Dataset :

The dataset consists of two tables:

• countries: Contains information about different countries and their respective continents.

• international_debt: Contains information about the amount of debt owed by developing countries in various categories.

• International Debt Statistics Case Study

How to Use This Repository

Feel free to explore the folders and files in this repository. Each project folder contains detailed instructions, SQL scripts, and documentation. You can clone the repository and run the SQL scripts on your local machine to see the results for yourself.

Contact

If you have any questions or would like to collaborate on a project, please reach out to me via LinkedIn

Pratiti Soumya