I'm embarking on a dedicated journey to significantly enhance my SQL proficiency, and I believe the most effective way to achieve this is through consistent practice and documentation. To that end, I've committed to solving the "SQL 50" study plan problems on LeetCode. This repository serves as a personal log of my progress and a valuable resource for anyone looking to sharpen their SQL skills, from aspiring data professionals to beginners just starting their SQL learning path.
My approach is simple yet effective: every day, I will solve one LeetCode SQL problem and meticulously document its solution in this GitHub repository. Each solution will be provided in a clear, well-commented Markdown file, ensuring that the logic and query structure are easily understandable.
This initiative is not just for my personal growth; it's also designed to benefit the broader learning community. By openly sharing my solutions and thought processes, I aim to provide practical examples and insights that can help others navigate the complexities of SQL and build a strong foundation in database querying. Whether you're aiming to ace technical interviews, improve your data analysis capabilities, or simply learn SQL from scratch, I hope this repository proves to be a useful companion on your learning journey.
- LeetCode: The primary platform for problem-solving.
- MySQL: The SQL dialect primarily used for solutions, as it's widely supported on LeetCode.
- GitHub: For version control and hosting this repository.
- Markdown: For documenting solutions and this
README.mdfile.
| Problem Name | Solution Link |
|---|---|
| 1. Recyclable and Low Fat Products | Solution |
| 2. Find Customer Referee | Solution |
| 3. Big Countries | Solution |
| 4. Article Views I | Solution |
| 5. Invalid Tweets | Solution |
| 6. Replace Employee ID With The Unique Identifier | Solution |
| 7. Product Sales Analysis I | Solution |
| 8. Customer Who Visited but Did Not Make Any Transactions | Solution |
| 9. Rising Temperature | Solution |
| 10. Average Time of Process Per Machine | Solution |
| 11. Employee Bonus | Solution |
| 12. Students and Examinations | Solution |
| 13. Managers with at Least 5 Direct Reports | Solution |
| 14. Confirmation Rate | Solution |
| 15. Not Boring Movies | Solution |
| 16. Average Selling Price | Solution |
| 17. Project Employees I. | Solution |
| 18. Percentage of Users Attended in a Contest. | Solution |
| 19. Queries Quality and Percentage. | Solution |
| 20. Monthly Transaction I. | Solution |
I will update the badge at the top of this README.md to reflect my progress in solving the 50 SQL problems.
This section will eventually contain a more detailed progress bar or status once I've implemented a way to automate its updates.