select OrderType,avgTotal from (select OrderType,avg(Total) as avgTotal from sales group by OrderType) temporder by avgTotal desc
