Practice SQL Group Functions | HR

This page provides exercises and solutions to help you practice SQL Group Functions. These exercises are based on the HR 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 (Employees table).
  2. Display the highest last name alphabetically (Employees table).
  3. Display the number of rows in Employees table.

To read more

UpScale Analytics is one of the largest platforms in the world for learning SQL by doing, consisting over 300 SQL exercises at different levels (including solutions), by topics, across over 100 different datasets. More…