select  a.CUST_CODE as CODE,
        b.CUST_NAME as NAME,
        count(b.CUST_CODE) as CNT,
        sum(a.ORDER_AMNT) as TTL_AMT,
        round(avg(a.ORDER_AMNT), 0) as AVG_AMT
from    ORDERS a
left join CUSTOMER b on a.CUST_CODE = b.CUST_CODE
where   a.ORDER_DATE > "2023-08-31" and
        a.ORDER_DATE < "2023-10-01"
group by a.CUST_CODE
         having CNT > 4
order by CNT desc,
         AVG_AMT desc,
         CODE asc
limit 5;