Sort by average?

Question

MySQL

Hello. How to sort records by arithmetic mean?
I have a table
id|price1|price2|price3
How to get the average of all prices and sort by it?

Answer 1

SELECT id,  ((price1 + price2 + price3)/3) as avgprice FROM table ORDER BY avgprice