SQL Devs! Will this query return orders that have no refunds at all?

Published on 9 Feb 2026, 14:01

Here’s a SQL challenge that shows up in real production code more often than people expect. We’re selecting all orders and optionally joining refund data, but only for refunds over $100. At a glance, the LEFT JOIN makes it feel safe. But the final result doesn’t behave the way you might assume. Will orders with no refunds be returned by this query?

Subscribe to Google for Developers → goo.gle/developers

Speakers: Jasmyne Roberts