|
|
|
|
|
|
|
|
|
|
version 11
AVG ([ALL | DISTINCT] arithmetic_expression)
Description
The AVG function returns the average of the arithmetic_expression. The optional ALL and DISTINCT keywords are used to respectively retain or eliminate any duplicate values.
Example
This example returns the minimum value of tickets sold, the maximum value of tickets sold, the average of the tickets sold and the total amount of tickets sold for the MOVIES table:
SELECT MIN(Tickets_Sold), MAX(Tickets_Sold), AVG(Tickets_Sold), SUM(Tickets_Sold) FROM MOVIES
See Also
|
|
|
|
|
|
|
|
|
|