Kikoff Interview Question

Typical SQL questions that involve window functions