LeetCode SQL 50 Challenge

Welcome to my public log for the LeetCode SQL 50 Challenge.

As a Data Engineer, I believe SQL is the absolute backbone of scalable data infrastructure. You cannot build efficient pipelines or extract real business insights if your core data foundations are weak.

This repository documents my daily progress as I solve 3 SQL questions a day, scaling from basic SELECT statements up to complex JOINs, CTEs, and Window Functions.

Repository Structure

To keep things organized, every day has its own dedicated folder containing the raw .sql files and a daily README.md explaining the logic and edge cases.

• Day-01/ - Basic Selects
• Day-02/ - Basic Joins
• (Updates daily!)

How to Contribute

I am building this in public and I want this repository to be a resource for the data community. I highly encourage you to contribute!

What you can contribute:

• Optimizations: Did you find a more efficient way to write a query?
• Alternative SQL Dialects: I primarily write in MySQL. If you want to add the equivalent query in T-SQL or Oracle, go for it!
• Edge Cases: See a flaw in my logic? Fix it!

Steps to contribute:

1. Fork this repository to your own GitHub account.
2. Clone it to your local machine.
3. Create a new branch: git checkout -b feature/optimize-day-1
4. Add your solution (e.g., 1757_alternative_solution.sql).
5. Commit your changes: git commit -m "Added optimized PostgreSQL solution for Q 1757"
6. Push to your branch: git push origin feature/optimize-day-1
7. Open a Pull Request (PR) here on my main repository!

I will review PRs daily and merge the best ones. Let's build these data muscles together.

Let's Connect

Follow the daily updates and discussions on X: https://x.com/Wuod_Nyasaye