Pergunta de entrevista da empresa Accenture

Basic SQL queries involving group by and window functions like lead and lag