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

34 Views

Thanks! Share it with your friends!

You disliked this video. Thanks for the feedback!

Published Feb 10, 2026

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 → https://goo.gle/developers

Speakers: Jasmyne Roberts

Category: Project
Tags: Google, developers, pr_pr: Google for Developers;

Be the first to comment

Sign in

Create your account

Add Video

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

Up Next