Compute SQL Function Not Supported

[Brandon Lewis]

I take it the Computer SQL Function is not support by MySQL and if not is
there a substitute for it?

If you are unfamiliar with the command it works like this:

SELECT type, price
FROM products
ORDER BY type
COMPUTE SUM(price)

You will get a summary of prices by type in your results.