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-game-training-sql 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).