Chapter 10

1. To group rows that have the same values into summary rows.
2. Use the WHERE clause before the GROUP BY clause.
3. They wind up returning the same results.
4. Use ORDER BY clause after the GROUP BY clause.
5. ROLLUP.
6. To filter the GROUP BY results.
7. Yes.
8. SELECT
   FROM/JOIN
   WHERE
   GROUP BY
   HAVING
   ORDER BY
   LIMIT
9. FROM/JOIN
   WHERE
   GROUP BY
   HAVING
   SELECT
   ORDER BY
   LIMIT