Total quantity

SELECT sum(SalePrice)

FROM Products p

INNER JOIN Sales s ON s.ProductID = p.ProductID

group by ProductName

The output should be the total quantity sold for each product and return a print statement that reads (as an example) a total of 7 monitor(s) were sold you can...

Hi thank you for ur help

the output should be print statement

for example total quantity sold for each product and return a print statement that reads (as an example) a total...

how can i get the total quantity.