Avg
Overview
The avg function computes the average value of a numeric field within a specified schema, working on the values in the documents of that field. It's utilized alongside the SELECT statement to fetch the average of values in the designated field across the documents within the schema.
Example
Selects documents from the FlatTranslate schema and determines the average value of Id.
SELECT
German,
Avg(Id)
FROM
WordList:FlatTranslate
WHERE
English LIKE 'Cat%'
GROUP BY
German
See Also
Related