Anyone know how to nest a function within another

Question

for example MAX (SUM (TableColumn))
every time I do this I get an error
please help

Answer 1

xTRIGRAMx SELECT SUM(Amount)
FROM [Order]
WHERE Avg(Amount) > 30
did you mean a query like this.
or it will be very good if you share your code
or explain what actual query do u want to run?

Answer 2

xTRIGRAMx SELECT SUM (AVG(column1)+AVG (column2)) FORM orders