Mapping subquery and aggregate functions
映射子查询和聚合功能
A third method is to have the summary tables rebuilt after the ETL process using SQL sum and aggregate functions.
第三种方法是在ETL流程之后使用SQL SUM和汇总函数来重构汇总表。
I can then use built-in aggregate functions on the array to get the size and sum of those days overdue and compute an average.
然后我可以使用内置的聚合函数来获取过期天数的大小和总和并计算平均值。
应用推荐