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:
  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: