1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Oracle SQL
Beta

Exercise

Getting started with group functions

The accounting department of eSymphony needs a report with the lowest, highest, sum, and average invoice amounts. The columns need to be labeled MINIMUM, MAXIMUM, SUM, and AVERAGE, respectively.

MINIMUM MAXIMUM SUM AVERAGE
0.99 25.86 2328.6 5.651942

Let's help them out.

Instructions 1/2

undefined XP
    1
    2
  • Calculate the minimum, maximum, sum, and average of the Total invoice amount.
  • Retrieve the data from the Invoice table.