Pregunta de entrevista de Block

Standard SQL interview on how to group, aggregate and join