hard20 pts · first answer countssqlaggregation
SUM(DISTINCT) gives a low total
A customer has three payments: ₹500, ₹500 and ₹300. An analyst used SUM(DISTINCT amount) to "avoid double counting" after a join. What does it return for this customer?
Discussion 0
Join free to post in the discussion.