Fifth Third interview question

One sql join and group question