all aggregation functions passing tests.