05. Advanced Queries

Overview

Moving beyond basic SELECTs, we learn how to summarize data and combine results.

Topics Covered

• Aggregate Functions: SUM, AVG, COUNT, MIN, and MAX.
• GROUP BY & HAVING: Summarizing data by categories and filtering aggregated results.
• Set Operations: Combining result sets with UNION, INTERSECT, and EXCEPT.
• The DISTINCT Keyword: Eliminating duplicates from queries.