Pergunta de entrevista da empresa Coca-Cola Consolidated

Live coding with SQL and asked to explain the code.