Skip to main content

SQL aggregation · 5 minutes

Keep two genuine equal-value sales

Get feedback on your answer. No account needed.

Two different sale lines on a receipt both cost 8. The report uses SUM(DISTINCT amount) to repair a join. What sales total will it report for those lines?

Your answer
Need a small hint?

DISTINCT operates on the expression passed to SUM.

This helps us choose when to schedule your next review.