Is there a way re-write multiple aggregate statement above? right now I can only think that that needs to split into two statements.

MongoDB can group by multiple elements in a group, then we can do a sum like

MongoDB: Function "count()" returns sum instead of number of rows ----------------------------------------------------------------- Key: TEIID-2983 URL: https://issues.jboss.org/browse/TEIID-2983 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.7.1 Reporter: Van Halbert Assignee: Ramesh Reddy Labels: Beta1 Fix For: 8.7.1, 8.8 Function "count()" returns sum of rows instead of number of rows Query [1] returns sum of values of all rows of IntKey column. Query [2] correctly returns number of rows [1] SELECT COUNT(IntKey) FROM BQT1.SmallA [2] SELECT COUNT(*) FROM BQT1.SmallA