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
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Calculate the required values from the Invoice table
SELECT ___,
___,
___,
___
___ ___