SQL Practice

📘 Overview

This repository contains hands-on SQL practice exercises created while learning and strengthening SQL skills for data analytics. It covers fundamental to advanced SQL concepts.

The focus is on writing clean, readable, and efficient queries commonly used in real-world data analysis roles.

---

🎯 Goals

• Build a strong foundation in SQL for data analysis
• Practice writing queries for data exploration and reporting
• Understand how to work with real-world datasets
• Improve query logic, readability, and performance

---

🧠 Topics Covered

• Basic SELECT statements
• Filtering with WHERE
• Sorting and limiting results
• Aggregate functions (COUNT, SUM, AVG, MIN, MAX)
• GROUP BY and HAVING clauses
• JOINs (INNER, LEFT, RIGHT)
• Subqueries
• CASE WHEN statements
• Window functions (basic usage)

---

📂 Repository Structure

sql-practice/ │── basics/ │── filtering/ │── aggregates/ │── joins/ │── subqueries/ │── case-when/ │── window-functions/ │── practice-problems/ │── datasets/ │── README.md

Each folder contains SQL scripts and practice problems related to a specific topic.

---

🛠 Tools & Environment

• SQL (PostgreSQL / MySQL syntax)

---