Pergunta de entrevista da empresa Fifth Third

One sql join and group question