GROUP BY Fundamentals

HAVING Clause

LEFT/RIGHT/FULL OUTER JOIN

Multiple Table Joins

Count orders per customer including zero

Calculate total sales by product category

Find average order value by customer segment

How to count with LEFT JOIN?

Difference between WHERE and HAVING?

How to avoid double-counting in joins?