SQL-50 LeetCode Solutions

This repository contains my solutions to the 50 SQL problems on LeetCode. I aim to solve one problem per day and add my solutions here. The goal of this project is to practice and improve my SQL skills, focusing on various types of SQL queries, optimization techniques, and solving real-world database challenges.

---

Table of Contents

• Overview
• Problems Solved
• How to Use
• Contributing
• License
• Topics

---

Overview

The SQL-50 LeetCode Solutions repository is a collection of SQL queries and their solutions to the 50 SQL problems on LeetCode. The repository is intended to help developers improve their SQL problem-solving skills by practicing with real-world examples.

---

Problems Solved

As of today, I have solved the following problems:

1. Recyclable and Low Fat Products
2. Find Customer Referee
3. Big Countries
4. Article Views I
5. Invalid Tweets
6. Replace Employee ID With The Unique Identifier
7. Product Sales Analysis I
8. Customer Who Visited but Did Not Make Any Transactions
9. Rising Temperature
10. Average Time of Process per Machine
11. 577. Employee Bonus
12. 1280. Students and Examinations
13. 570. Managers with at Least 5 Direct Reports
14. 1934. Confirmation Rate
15. 620. Not Boring Movies
16. 1251. Average Selling Price
17. 1075. Project Employees I
18. 1633. Percentage of Users Attended a Contest
19. 1211. Queries Quality and Percentage
20. 1193. Monthly Transactions I
21. 1174. Immediate Food Delivery II(Current)

I will continue to add solutions daily.

---

How to Use

1. Clone the repository to your local machine:

   git clone https://github.com/mennaabdelelhady/SQL-50.git

2. Navigate to the project directory:

   cd SQL-50

3. Browse through the individual solutions, which are named according to the problem number.

You can test the SQL queries using your preferred SQL platform (e.g., MySQL, PostgreSQL, SQLite).

---

Contributing

Feel free to fork the repository, submit issues, or open pull requests with additional SQL solutions or improvements to existing ones. Here are some ways you can contribute:

• Solve additional SQL problems and submit a pull request.
• Help improve the performance or readability of existing solutions.
• Suggest new features or optimization techniques.

---

License

This repository is open-source and available under the MIT License.

---

Topics

• SQL
• LeetCode
• Database
• Query Optimization