Relational interview question

Had to do a Group By in SQL, that was the most "difficult" thing.