PACCAR interview question

Advanced SQL queries and window functions