This page provides exercises and solutions to help you practice SQL Aggregate functions. These exercises are based on the ACDB database, and may be performed online or by running the sample schema scripts on your local database server. For additional exercises in other subjects, use this link.
 

Part 1 – Basic Usage

  1. Display the lowest last name alphabetically (Customers table).
  2. Display the average monthly payment (Packages table).
  3. Display the highest last name alphabetically (Customers table).

Would you like to read more?