sql-practice-lab

This repository is designed to help you practice and master SQL concepts step by step. Folder Structure

1. 01_basics → SELECT, WHERE, ORDER BY, LIMIT
2. 02_joins → INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
3. 03_subqueries → Nested queries, correlated subqueries
4. 04_window_functions → RANK, DENSE_RANK, ROW_NUMBER, PARTITION BY
5. 05_case_statements → Conditional logic in SQL
6. 06_aggregate_functions → SUM, AVG, COUNT, GROUP BY, HAVING
7. 07_real_world_case_studies → End-to-end SQL problems for analysis.

How to Use

1. Clone this repo or download the ZIP.
2. Practice each section step by step.
3. Add your own queries and notes.