Global-e Interview Question

how to use aggregation in sql