SQL Aggregates

Learning Objectives

• Compute aggregate expressions over retrieved data using the GROUP BY and HAVING clauses
• Organize retrieved data using the ORDER BY clause

How to Complete this Lesson

Complete the following learning activities: (2–2.5 hours total)

1. Complete the following lessons from Select Star SQL:
   • Claims of Innocence (30–45 minutes)
   • The Long Tail (30–45 minutes)
2. Attend the class meeting (60 minutes)
3. Complete the practice queries

---

« SQL SELECT SQL Joins »