Pregunta de entrevista de Coca-Cola Consolidated

Live coding with SQL and asked to explain the code.