Pregunta de entrevista de Fifth Third

One sql join and group question