Deloitte interview question

Aggregation function in SQL and usage