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

Author: Google for Developers - Bewertung: 4x - Views:43

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