Problem 2752 · Medium

Customers with Maximum Number of Consecutive Days

SQL walkthrough: collapse each customer’s days, group consecutive dates into streaks, and keep the longest. The sample tables are invented for teaching.

Open the interactive visualisation