Fifth Third Interview Question

One sql join and group question