Skip to main content

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?

Your answer
Need a small hint?

Start from the table containing the whole reporting population.

This helps us choose when to schedule your next review.