How could I have MySQL sum() and group by clause within my elasticsearch query?

Have a look at aggregations, in particular the terms and sum aggregations.

1 Like