SQL Interview Problem: The Suspicious Split (+ 2 Challenges to Solve Yourself)

My Live SQL Bootcamp is back - the first one in over a year! 8 live sessions, Beginner to Advanced, starting Sept 5. Seats are limited ????
https://sqlnest.com/bootcamp/Live_SQL_Bootcamp_Beginner_to_Advanced

In today's video, I'm solving a brand-new SQL interview problem, "The Suspicious Split" - a self-join mind-twister built around catching expense-splitting fraud and explaining exactly why the obvious LAG() approach fails on it.

I've also got 2 more original problems in this video that I'm NOT solving on camera, "The Bundle Completionist" and "Peak Hour." Those are yours to try. Both are free on SQLNest (for up to 1 week) with verified solutions in PostgreSQL, MySQL, SQL Server, and Oracle.

Check out the BEST-practice platform to solve SQL problems ????
https://sqlnest.com/

Problem 1 - The Suspicious Split
https://sqlnest.com/queryhub/query/bp75EiyddQfjGYHFRKdZZr?listPage=1

Problem 2 - Peak Hour
https://sqlnest.com/queryhub/query/dQxQLVnyZq52mNxmhYrH6J?listPage=1

Problem 3 - The Bundle Completionist
https://sqlnest.com/queryhub/query/eKUtyWZtmq19N3ACLwGrnG?listPage=1

???? Drop your answers to the 2 challenge problems below - I'll check them.

#sql #dataengineering...