GitHub - Ganesh20000/Leetcode_sql_top_50: A collection of the Top 50 SQL problems with solutions — covering SELECT, JOINs, GROUP BY, subqueries, window functions, and advanced queries. Perfect for practice, interviews, and learning SQL step by step.

Ganesh20000 / Leetcode_sql_top_50 Public

Notifications You must be signed in to change notification settings
Fork 0
Star 1

A collection of the Top 50 SQL problems with solutions — covering SELECT, JOINs, GROUP BY, subqueries, window functions, and advanced queries. Perfect for practice, interviews, and learning SQL step by step.

1 star 0 forks Branches Tags Activity

Star

Notifications

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 34 Commits
1153-product-sales-analysis-i		1153-product-sales-analysis-i
1317-monthly-transactions-i		1317-monthly-transactions-i
1338-queries-quality-and-percentage		1338-queries-quality-and-percentage
1509-replace-employee-id-with-the-unique-identifier		1509-replace-employee-id-with-the-unique-identifier
1724-customer-who-visited-but-did-not-make-any-transactions		1724-customer-who-visited-but-did-not-make-any-transactions
1773-percentage-of-users-attended-a-contest		1773-percentage-of-users-attended-a-contest
1827-invalid-tweets		1827-invalid-tweets
1908-recyclable-and-low-fat-products		1908-recyclable-and-low-fat-products
595-big-countries		595-big-countries
readme		readme

Repository files navigation

# SQL Top 50 Problems 🚀

A curated collection of the **Top 50 SQL problems** with step-by-step solutions.  
This repo is designed for **beginners**, **students**, and **interview preparation**.  
It covers everything from **basic queries** to **advanced SQL concepts**.

---

## 📌 Topics Covered
- ✅ Basic SELECT statements  
- ✅ Filtering with `WHERE`  
- ✅ Sorting with `ORDER BY`  
- ✅ Aggregate functions (`COUNT`, `SUM`, `AVG`, `MIN`, `MAX`)  
- ✅ GROUP BY & HAVING  
- ✅ Subqueries (Single-row & Multi-row)  
- ✅ JOINs (INNER, LEFT, RIGHT, FULL)  
- ✅ Set operations (UNION, INTERSECT, EXCEPT)  
- ✅ Window functions (RANK, DENSE_RANK, ROW_NUMBER, LAG, LEAD)  
- ✅ String & Date functions  
- ✅ Case statements & conditional queries  

---

## 📂 Repository Structure