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.
Bu egzersiz
Introduction to Oracle SQL
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Calculate the required values from the Invoice table
SELECT ___,
___,
___,
___
___ ___