SQL aggregation · 5 minutes
Include a receipt with no refund
Get feedback on your answer. No account needed.
A refunds subquery returns one total per refunded receipt. The report must include all receipts and show 0 for missing refunds. Which outer query fits?
