Accenture interview question

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