How to find consecutive streaks in data using SQL window functions (and identify cheaters in Halo 5)
Data with Zach
•
June 5, 2022
Data with Zach
View ChannelAbout
Learn data engineering from the best! I worked for two years at Facebook as a data engineer in 2016-2018. I worked for two years at Netflix as a senior data engineer and senior software engineer in 2018-2020. I worked for two years at Airbnb as a staff data engineer! Follow me on all social media: @EcZachly I have a dog named Lulu who I love very much! 350k followers on LinkedIn; Skilled at data engineering, analytics engineering, and software engineering; advocate for mental health
Latest Posts
![LeetCode 1454: Active Users [SQL]](https://imgz.pc97.com/?width=500&fit=cover&image=https://i.ytimg.com/vi/E2hkrgwSGhw/hqdefault.jpg)
Upgrade Your Gaming Audio
AI-recommended products based on this video
Loading...
HyperX Cloud II - Gaming Headset, 7.1 Surround Sound, Memory Foam Ear Pads, Durable Aluminum Frame, Detachable Microphone, Works with PC, PS5, PS4, Xbox Series X|S, Xbox One – Red
(73,207)
$89.99
FREE delivery Thu, Aug 21
500+ bought in past month
Loading...
New SteelSeries Arctis Nova Pro for Xbox Multi-System Gaming Headset - Premium Hi-Fi Drivers - Hi-Res Audio - 360° Spatial - GameDAC Gen 2 - Quad-DAC - ClearCast Gen 2 Mic - Xbox, PC, PS5/PS4, Switch
(517)
$209.41$122.65
PrimeFREE delivery Sat, Jun 14
Loading...
NEW SteelSeries Arctis Nova 3 Multi-Platform Gaming Headset - Signature Arctis Sound - ClearCast Gen 2 Mic - PC, PS5/PS4, Xbox Series X|S, Switch, Mobile
(9,500)
$99.98$67.37
PrimeFREE delivery Sat, Jun 14
100+ bought in past month
Loading...
Best Seller
Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black
(17,871)
$27.98$22.38
FREE delivery Tue, Oct 14 on your first order
500+ bought in past month
Loading...
Logitech G305 LIGHTSPEED Wireless Gaming Mouse, Hero 12K Sensor, 12,000 DPI, Lightweight, 6 Programmable Buttons, 250h Battery Life, On-Board Memory, PC/Mac - Black
(21,223)
$44.98
FREE delivery Tue, Oct 14
1K+ bought in past month
Loading...
Best Seller
Logitech K400 Plus Wireless Touch TV Keyboard With Easy Media Control and Built-in Touchpad, HTPC Keyboard for PC-connected TV, Windows, Android, Chrome OS, Laptop, Tablet - Black
(38,516)
$39.98$35.98
FREE delivery Thu, Sep 4
500+ bought in past month
Loading...
Logitech M185 Wireless Mouse, 2.4GHz with USB Mini Receiver, 12-Month Battery Life, 1000 DPI Optical Tracking, Ambidextrous, Compatible with PC, Mac, Laptop - Black
(43,809)
$14.99$11.99
FREE delivery Mon, Sep 22 on your first order
1K+ bought in past month
Loading...
Bose QuietComfort Wireless Noise Cancelling Headphones, Bluetooth Over Ear Headphones with Up to 24 Hours of Battery Life, Moonlight Grey - Limited Edition
(12,251)
$269.00
FREE delivery Tue, Oct 14
Loading...
HyperX Cloud II - Gaming Headset, 7.1 Surround Sound, Memory Foam Ear Pads, Durable Aluminum Frame, Detachable Microphone, Works with PC, PS5, PS4, Xbox Series X|S, Xbox One – Red
(73,207)
$89.99
FREE delivery Thu, Aug 21
500+ bought in past month
Loading...
CORSAIR iCUE Link XD5 RGB Elite LCD Pump-Reservoir Unit - D5 PWM Pump - 480x480 IPS LCD Screen - 22 Addressable RGB LEDs - 440ml Nylon Reservoir - White
(17)
$379.99
FREE delivery Sun, Aug 24
Loading...
CORSAIR iCUE Link XC7 RGB Elite CPU Water Block - Transparent Flow Chamber - 24 RGB LEDs - Fits Intel® LGA 1700, AMD® AM5 and Older - White
(56)
$149.99$125.33
FREE delivery Sun, Aug 24
Loading...
CORSAIR Hydro X Series iCUE Link XH405i Custom Cooling Kit – Hardline Water Cooling Loop – XC7 Elite CPU Water Block – XD5 Elite D5 Pump Res – XR5 360mm Radiator – 3X QX120 RGB Fans
(235)
$879.99
FREE delivery Sun, Aug 24
Loading...
Best Seller
Turtle Beach Stealth 600 Wireless Multiplatform Amplified Gaming Headset for Xbox Series X|S, Xbox One, PC, PS5, PS4, Nintendo Switch, & Mobile – Bluetooth, 80-Hr Battery, Noise-Cancelling Mic – Black
(3,680)
$99.96
FREE delivery Tue, Oct 14
800+ bought in past month
Loading...
Turtle Beach Stealth Ultra High-Performance Wireless Gaming Controller Licensed for Xbox Series X|S, Xbox One, Windows PC & Android – LED Dashboard, Charge Dock, RGB Lighting, 30-Hr Battery, Bluetooth
(1,771)
$224.95$199.41
PrimeFREE delivery Sat, Jun 14
Loading...
HyperX Cloud II - Gaming Headset, 7.1 Surround Sound, Memory Foam Ear Pads, Durable Aluminum Frame, Detachable Microphone, Works with PC, PS5, PS4, Xbox Series X|S, Xbox One – Red
(73,207)
$89.99
FREE delivery Thu, Aug 21
500+ bought in past month
Loading...
Spy Camera, Hidden Camera 4K Ultra HD with 4H Battery Life, SD Card & Cloud Storage, Motion Detection Alarm, Real-Time App Alerts, 2.4G WiFi & Night Vision for Home/Office Security
(127)
$33.99
Prime
1K+ bought in past month
Loading...
![Samsung EVO Select Micro SD Memory Card + Adapter, 256GB microSDXC 160MB/s Full HD & 4K UHD, UHS-I, U3, A2, V30, for Android Smartphones, Tablets, Nintendo-Switch (MB-ME256SA/AM) [Canada Version]](https://m.media-amazon.com/images/I/71gQWJ9ufdL._AC_UL960_FMwebp_QL65_.jpg)
Samsung EVO Select Micro SD Memory Card + Adapter, 256GB microSDXC 160MB/s Full HD & 4K UHD, UHS-I, U3, A2, V30, for Android Smartphones, Tablets, Nintendo-Switch (MB-ME256SA/AM) [Canada Version]
(11,340)
$34.99
FREE delivery Sat, Jun 14 on your first order
200+ bought in past month
Loading...
IdeaPad 3 14" HD Laptop - Intel Pentium Silver N5030, 4GB RAM, 128GB SSD, Windows 10 S Mode - Platinum Grey (81WH004LUS)
(142)
$259.99
FREE delivery Sun, Jun 22
Loading...
KOOTION 128GB Micro SD Card 2 Pack Micro SDXC UHS-I High Speed up to 90MB/s TF Card 128GB Card Memory U3,A1,V30, Full HD Video for Drone/Smartphone/Camera/Dash Cam/PC/Tablet
(1,370)
$20.89
FREE delivery Sun, Aug 10 on your first order
300+ bought in past month