multiple aggregations at once

[luongdai]

Hi,

Based on your API document that the current version does not support multiple aggregations at once and that you need to use inner join of two queries statement, can you provide an example of inner join for two queries results? An example of the output as below:

Location Dollar
A 5
B 3
A 2
C 1

Location Count Sum Avg
A 2 7 3.5
B 1 3 3
C 1 1 1

Thanks for your help.