SQL Aggregates

Preparation

Fundamentals of Database Management Systems

• Chapter 4: Relational Data Retrieval: SQL

Learning Objectives

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

Practice

Complete the lab as time permits in class (or outside of class)