One query. One bug. Find it.
Debug ECHO
ECHO says:
I wrote these queries for Sidekick Supply Co and they all look PERFECT to me. Each one has exactly one bug, allegedly. Prove it!
Guests can try the first 2 challenges. Sign in for 5 a day (and XP).
Easy
- #01The Vanishing Window-Shopperseasy๐ INNER vs LEFT JOIN
- #02The Email Black Holeeasy๐ NULL comparisons
- #03Counting Ghost Inboxeseasy๐ COUNT(*) vs COUNT(column)๐ Sign in
- #04Big Spenders, Small Receiptseasy๐ WHERE vs HAVING๐ Sign in
- #05The Missing Last Dayeasy๐ Off-by-one date range๐ Sign in
- #06Zero Percent Cancelled?!easy๐ Integer division๐ Sign in
- #07The Department That Wasn'teasy๐ INNER vs LEFT JOIN๐ Sign in
- #08City and Tier, Allegedlyeasy๐ Missing GROUP BY column๐ Sign in
- #09Tickets From Nowhereeasy๐ COUNT(*) vs COUNT(column)๐ Sign in
- #10Not Gold, Not Countedeasy๐ NULL comparisons๐ Sign in
Medium
- #11The LEFT JOIN That Turned INNERmedium๐ Filter on a LEFT JOIN's right table๐ Sign in
- #12Two Alex Kims Walk Into a Reportmedium๐ Missing GROUP BY column๐ Sign in
- #13Nothing Sells More Than 4?medium๐ WHERE vs HAVING๐ Sign in
- #14Discounts Everywheremedium๐ COUNT(*) vs COUNT(column)๐ Sign in
- #15Nobody Is Not a Managermedium๐ NULL comparisons๐ Sign in
- #16The Ticket at 3:20 PMmedium๐ Off-by-one date range๐ Sign in
- #17Revenue, Multipliedmedium๐ Join fan-out double counting๐ Sign in
- #18Third Place, Party of Severalmedium๐ ORDER BY / LIMIT ties๐ Sign in
- #19Exactly Two Units. Always.medium๐ Integer division๐ Sign in
- #20The Customer Censusmedium๐ DISTINCT hiding a bug๐ Sign in
Hard
- #21The NULL-Shaped Loopholehard๐ Filter on a LEFT JOIN's right table๐ Sign in
- #22DISTINCT Fixed Half of Ithard๐ Join fan-out double counting๐ Sign in
- #23The Suspiciously Even Apparel Billhard๐ DISTINCT hiding a bug๐ Sign in
- #24Averages With Extra Weighthard๐ Join fan-out double counting๐ Sign in
- #25Everyone's First Orderhard๐ Wrong window partition๐ Sign in
- #26Tiny Slices of Everythinghard๐ Wrong window partition๐ Sign in
- #27Number One at Everythinghard๐ Wrong window partition๐ Sign in
- #28The Latest Order, From 2025-09hard๐ ORDER BY / LIMIT ties๐ Sign in
- #29Web Orders Need Not Applyhard๐ INNER vs LEFT JOIN๐ Sign in
- #30The Two-Hop Traphard๐ Filter on a LEFT JOIN's right table๐ Sign in