How to find consecutive streaks in data using SQL window functions (and identify cheaters in Halo 5)

Описание к видео 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).

Комментарии

Информация по комментариям в разработке

Похожие видео