Pergunta de entrevista da empresa XYZ

Basics of SQL. Normalization Joins Group by clause