Wells Fargo Interview Question

Need for group by clause in SQL