One naive example is ``` CREATE AGGREGATE FUNCTION fun (a INT64, b INT64) AS (SUM(a)/AVG(b)); ``` Imported from Jira [BEAM-9954](https://issues.apache.org/jira/browse/BEAM-9954). Original Jira may contain additional context. Reported by: amaliujia.