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

Estimated read time 1 min read

Post Contenthttps://www.youtube.com/shorts/YMZGfG9P2lM

​ 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   Read More Google for Developers 

You May Also Like

More From Author