Pro question

Rolling seven-day cancellation rate

SQL & Data Modeling · Window Functions · hard · Original Uplift question · PostgreSQL · 22 min

For every calendar date from the first through last order date, compute the trailing seven-calendar-day cancellation rate: canceled orders divided by all orders in that date and the prior six dates.

This question is part of Pro

The prompt, fixtures, grading criteria and model write-up stay on the server until your plan unlocks them.

See plans Sign in

Source

Original Uplift question based on a common interview pattern.

Community

How other people solved this

There is rarely one right query or one right framing. Read how others approached it, and share your own once you have submitted an answer.

Reading is open to everyone. Sign in to share your approach or mark a write-up as helpful.

Loading write-ups…