select
    ORDERS.CUST_CODE as 'CODE',
    CUST_NAME as 'NAME',
    count(ORDERS.CUST_CODE) as 'CNT',
    sum(ORDER_AMNT) as 'TTL_AMT',
    round(sum(ORDER_AMNT)/count(ORDERS.CUST_CODE)) as 'AVG_AMT'
from ORDERS left join CUSTOMER on ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
where ORDER_DATE >= '2023-09-01' and ORDER_DATE <= '2023-09-30'
group by ORDERS.CUST_CODE
having count(ORDERS.CUST_CODE) >= 5
order by CNT desc, AVG_AMT desc, CODE asc
limit 5;