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.
Deze oefening maakt deel uit van de cursus
Introduction to Oracle SQL
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Calculate the required values from the Invoice table
SELECT ___,
___,
___,
___
___ ___