Solving the Classic SQL "Gaps and Islands" Problem: 3 Modern Approaches

If you've ever needed to find consecutive streaks in data — days a user logged in back to back,...