My solutions to SQL exercises from SQLZoo and HackerRank (MySQL dialect).
SQL Dialect: MySQL
This is a personal learning archive where I document solutions and reflections from SQL platforms like SQLZoo and HackerRank. Each file contains the original SQL exercise (paraphrased if required), my solutions, and comments explaining the logic and key takeaways.
All solutions are 💯 correct at the time of upload and include explanations to reinforce key SQL topics like queries, joins, subqueries, and more.
SELECT,WHERE,ORDER BYGROUP BY,HAVING, aggregate functionsJOIN(INNER, LEFT, RIGHT, FULL OUTER)- Subqueries and CTEs
- Window Functions (
RANK,DENSE_RANK,NTILE, etc.) CASEstatements, handlingNULL, filtering, and more
sqlzoo/— Solutions to all SQLZoo tutorials and quizzeshackerrank/— Paraphrased HackerRank challenges + solutions (in progress)- More sources may be added soon — e.g., LeetCode, StrataScratch, custom datasets
SQLZoo is a hands-on, beginner-friendly platform that helps you learn SQL from the ground up using real-world examples. I started with SQLZoo because of its structured progression and engaging challenges.
Keywords: SQL practice, SQL interview prep, SQLZoo answers, SQL exercises
-
Clone the repo:
git clone https://github.com/rlrightleft/learn-SQL-MySQL.git
-
Navigate to the folder of interest (
sqlzoo/,hackerrank/, etc.) -
Open individual
.mdfiles to explore solutions and review logic.
Learning notes are included to explain my approach and learning insights for each challenge.
I do not claim ownership of the original problem statements from SQLZoo, HackerRank, or any other third-party source. This repository is shared for educational and personal learning purposes only, with all proprietary content paraphrased where required.
Feel free to fork this repo and add your own solutions or reflections! Pull requests are welcome.
Have a suggestion or found a bug? Open an issue or message me on GitHub.
Happy querying! 😄