Trying to do an SQL statement, but I can't figure it out. I need to find which product has the highest overall sales and which has the lowest overall sales.
I have these columns to work from
PRODUCT
ProductID, ProductName
ORDER
OrderID, Itemid, ProductID, Price, QTY, Itemtotal
(Its from the...