For customer_id = 101: amounts are 500 + 700 = 1200. For customer_id = 102: amount = 300. The query uses GROUP BY customer_id, which correctly groups and sums amounts.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback