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.
SQL walkthrough: collapse each customer’s days, group consecutive dates into streaks, and keep the longest. The sample tables are invented for teaching.