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: (3–3.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
4. Work on the SQL programming exercise (PEX) (60 minutes)
   • Complete queries 11–15 (LargeCo database)

Due

As a reminder, the following is due this lesson:

• Project: Schema Design

---

« SQL SELECT

SQL Joins »