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

1. Read Fundamentals of Database Management Systems Chapter 4: Relational Data Retrieval: SQL (60 minutes)
2. Complete the following lessons from Select Star SQL:
   • Claims of Innocence
   • The Long Tail
3. Attend the class meeting
4. Complete the practice queries

---

« SQL SELECT SQL Joins »