This repository contains my solutions to the challenging SQL exercises from SQLZOO. SQLZOO is an interactive platform that provides a hands-on learning experience for SQL beginners and enthusiasts. Each exercise presents a real-world scenario and challenges you to write SQL queries to retrieve and manipulate data from a given database.
In this repository, you will find my solutions to some SQL exercises available on SQLZOO, specifically focusing on the hard ones. Each solution is organized in separate files, named according to the exercise number. The repository is structured as follows:
├── SQLZOO_Assessment Challenging Questions & Answers
├── exercise-1.sql
├── exercise-2.sql
├── exercise-3.sql
...
├── exercise-N.sql
├── LICENSE
├── README.md
├── SQLZOO_MySQL notes.sql
└── SQLZOO_Tutorial Challenging Questions & Answers.sql
The README.md file provides an overview of the repository and serves as a guide for anyone interested in using or exploring the project.
To use this project, follow these steps:
-
Clone the repository using this command:
git clone https://github.com/MaxineXiong/SQLZOO_solutions.git -
Ensure you have a compatible SQL database management system installed on your machine. Popular options include MySQL, PostgreSQL, SQLite, or Microsoft SQL Server.
-
Open the database management system and create a new database for executing the SQL exercises.
-
Execute the SQL files in the order of your choice, either by copy-pasting the content into your database management system's query editor or by running the files directly.
This repository is intended to be used as a reference for SQL learners or as a comparison for those who want to validate their own solutions. Feel free to explore the files and examine the queries to deepen your understanding of SQL concepts.
If you're using these solutions as a learning resource, it's recommended to attempt the exercises on SQLZOO first before referring to the solutions. Understanding the problem-solving process and developing your own solutions is crucial for gaining proficiency in SQL.
This project is licensed under the MIT License. Feel free to use, modify, and distribute the code in this repository.