Tricky~22min

The Canceled Subscription Still Streaming

12 accounts kept streaming after their paid_through date — well past the grace period they'd already paid for, meaning a device session token never got revoked. 18 more accounts also streamed after cancelling, but it was still before paid_through — completely legitimate use of access they'd already paid for.

Tables you'll query

subscriptionsplayback_events

What you'll learn

JOINsDate & Time Functions
Investigate this case →