How to find consecutive streaks in data using SQL window functions (and identify cheaters in Halo 5)
This Github repo for this video is here so you can follow along:
https://github.com/EcZachly/video-gam...
In this video we'll be using a data set I scraped from Halo 5 between 2015 and 2016. We'll use SQL to find players that have very long win streaks (who might be cheating).
We'll use LAG, SUM, and ROW_NUMBER to accomplish this with a bunch of common table expressions (i.e. CTEs).
