Skip to content

Latest commit

 

History

History
66 lines (42 loc) · 2.41 KB

README.md

File metadata and controls

66 lines (42 loc) · 2.41 KB

Learn SQL (MySQL)

My solutions to SQL exercises from SQLZoo and HackerRank (MySQL dialect).

About This Repo

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.

SQL Topics Covered

  • SELECT, WHERE, ORDER BY
  • GROUP BY, HAVING, aggregate functions
  • JOIN (INNER, LEFT, RIGHT, FULL OUTER)
  • Subqueries and CTEs
  • Window Functions (RANK, DENSE_RANK, NTILE, etc.)
  • CASE statements, handling NULL, filtering, and more

Current Sources

  • sqlzoo/ — Solutions to all SQLZoo tutorials and quizzes
  • hackerrank/ — Paraphrased HackerRank challenges + solutions (in progress)
  • More sources may be added soon — e.g., LeetCode, StrataScratch, custom datasets

Why SQLZoo?

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

How to Use This Repo

  1. Clone the repo:

    git clone https://github.com/rlrightleft/learn-SQL-MySQL.git

  2. Navigate to the folder of interest (sqlzoo/, hackerrank/, etc.)

  3. Open individual .md files to explore solutions and review logic.
    Learning notes are included to explain my approach and learning insights for each challenge.

Disclaimer

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.

Contributions & Feedback?

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! 😄