Calculate additional column and sort by it

[devoll]

How I can add additional calculated column and sort by it? Example SQL:

SELECT amount, fee, (amount - fee) as profit 
FROM payments 
WHERE client_id = 10 
ORDER BY profit 
DESC LIMIT 20, 10

Thank you!

[johanroyen]

You could do a raw query.