XYZ interview question

Basics of SQL. Normalization Joins Group by clause