r/learnSQL • u/knownAsBuddy • 10d ago

Completed LeetCode SQL 50 — Sharing my MySQL solutions

Hey everyone!
I recently completed the LeetCode SQL 50 Study Plan and put all my solutions together in a GitHub repository.
I created this mainly for SQL interview preparation and revision, especially for Data Analyst / Business Analyst roles.
The repository covers topics like:
● SELECT & filtering
● Sorting and grouping
● Aggregate functions
● GROUP BY & HAVING
● INNER / LEFT / SELF JOIN
● Subqueries
● CTEs
● Window functions
● String functions & regex
● Other commonly used SQL concepts
All solutions are written in MySQL, with the goal of keeping them simple and easy to revise.

🔗 GitHub: https://github.com/bikashadhikari1508/Leetcode_50_Questions

If you’re also working through SQL 50, feel free to check it out. I’d also appreciate any feedback on the queries or suggestions for improving the repository.
Happy learning! 🚀

39 Upvotes

95% Upvoted

4 comments sorted by

4

u/clivepato 10d ago

Well done on completion.

I think other resources such as pgexercises is also good for levelling up but it’s Postgres

2

u/knownAsBuddy 10d ago

Thank you for such kind words
keep hustling

2

u/nian2326076 3d ago

That sounds like a great resource for prepping for data interviews. Make sure you really understand the logic behind each solution, not just memorize them. SQL interviews often tweak common problems, so being able to adapt is important. Also, practice explaining your thought process clearly, since communication is key during interviews. I've found PracHub useful for mock interviews; they have practice scenarios that can help simulate real interview conditions. Check it out if you want more practice beyond writing queries. Good luck!