Deloitte Interview Question

Aggregation function in SQL and usage