max average value in MySql

Question

How to get the maximum from averages values in MySQL? The following query returns average values of amounts from table orders grouped by customers.

SELECT AVG(amount)
FROM orders
GROUP BY cust;

I want to receive a maximum value from average values using a single query with aggregate functions. Using ORDER BY ... DESC LIMIT 1 surely works, but what I am interested in is getting the maximum average value using aggregate functions solely. Is it possible at all? Thanks

Answer 1

select max(avg_value)
from 
(
  SELECT AVG(amount) avg_value FROM orders GROUP BY cust
) tmp