Welcome to the SQL Case Studies Repository! 🎉 This repository contains a collection of SQL case studies along with their data files, questions, and solutions.
🚀 This repository aims to provide practical exercises for learning SQL through real-world scenarios. Each case study presents a set of questions that require SQL queries to solve. Additionally, accompanying CSV data files are provided to facilitate data analysis and query execution.
The repository includes the following case studies:
-
This case study, based on the Zomato dataset provided by CampusX, guides you through basic SQL topics like joins, grouping, sorting, and filtering. You'll solve 18 practical problems related to analyzing restaurant orders, customer behavior, and menu items. This case study is ideal for beginners looking to practice and improve their fundamental SQL skills.
To use this repository:
- Clone or download the repository to your local machine.
- Set up a SQL environment (e.g., MySQL, PostgreSQL).
- Import the provided CSV data files into your SQL database.
- Open the
questions.mdfile in each case study folder to view the SQL questions. - Write SQL queries to solve the questions and execute them in your SQL environment.
- Check the
answers.sqlfile for the solutions to compare with your queries.
Contributions to this repository are welcome! 🌟 If you'd like to contribute:
- Fork the repository and create a new branch for your changes.
- Add or improve case studies, questions, solutions, or documentation.
- Submit a pull request with your changes, providing a clear description of the modifications.
Each case study folder contains the following files:
data*.csv: CSV files containing the data required for the case study. 📄questions.md: Markdown file containing the SQL questions for the case study. ❓answers.sql: SQL file containing the solutions to the questions. 💡
This repository is licensed under the MIT License, which means you are free to use, modify, and distribute the content for any purpose.