XYZ Interview Question

Basics of SQL. Normalization Joins Group by clause