Get startedGet started for free

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.

This exercise is part of the course

Introduction to Oracle SQL

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Calculate the required values from the Invoice table
SELECT ___, 
       ___, 
       ___, 
       ___
___ ___
Edit and Run Code