select
    C.cust_code 'CODE'
    ,cust_name 'NAME'
    ,count(order_no) 'CNT'
    ,sum(order_amnt) 'TTL_AMT'
    ,round(cast(sum(order_amnt) as real)/cast(count(order_no) as real), 0) 'AVG_AMT'
from
    orders O
    left join customer C on C.cust_code=O.cust_code
where
    order_date between '2023-09-01 00:00:00' and '2023-09-30 23:59:59'
group by
    C.cust_code
having
    count(order_no) >= 5
order by
    `CNT` desc
    ,`AVG_AMT` desc
    ,`CODE` asc
limit 5