Hello Experts,
How can I aggregate this CUSTOMERS table data using SQL code:
CustomerName CustomerID Amount
Maria 101 25
Maria 101 35
Maria 101 45
John 202 10
John 202 10
John 202 10
James 303 70
To make it look like this:
CustomerName CustomerID Amount
Maria 101 105
John 202 30
James 303 70