Questions

1. What does the GROUP BY clause allow you to do?
2. Do you use the WHERE clause before or after the GROUP BY clause?
3. What's the difference between a GROUP BY clause without aggregate functions and a DISTINCT query?
4. Do you use the ORDER BY clause before or after the GROUP BY clause?
5. What modifier can you use on the GROUP BY clause to get subtotals and grand totals?
6. What does the HAVING clause do?
7. What's the difference between the WHERE and HAVING clauses?
8. Can you use the WHERE and HAVING clauses together?
9. What order do you write query clauses in?
10. What order does MySQL execute query clauses in?