Filter & Agregasi

GROUP BY meringkas data, HAVING memfilter hasil agregat.

  SELECT category, COUNT(*) AS total, AVG(duration_minutes) AS rata
  FROM courses
  GROUP BY category
  HAVING total > 1
  ORDER BY total DESC;

Ingat urutan eksekusi: WHERE menyaring baris sebelum agregasi, HAVING sesudah.