- To group rows that have the same values into summary rows.
- Use the WHERE clause before the GROUP BY clause.
- They wind up returning the same results.
- Use ORDER BY clause after the GROUP BY clause.
- ROLLUP.
- To filter the GROUP BY results.
- Yes.
- SELECT
FROM/JOIN
WHERE
GROUP BY
HAVING
ORDER BY
LIMIT - FROM/JOIN
WHERE
GROUP BY
HAVING
SELECT
ORDER BY
LIMIT




















































