I am having the following query:
And then I get an error of aggregation. But how to achieve that?Code:SELECT
DATA.Account_Number AS Account_Number,
DATA.Service AS Service
DATA.Area AS Area,
SUM (DATA.Quantity) AS Quantity,
SUM (DATA.Amount) AS Amount
FROM DATA
GROUP BY DATA.Account_Number, DATA.Service, DATA.Area;
My goal is to use the account numbers, service and same area and add the quantity and value of transactions, if I summarize.