Accenture Interview Question

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