SELECT cs.CUST_CODE as CODE,
       cs.CUST_NAME as NAME,
       count(od.ORDER_NO) as CNT,
       sum(od.ORDER_AMNT) as TTL_AMT,
       round(avg(od.ORDER_AMNT),0) as AVG_AMT
        from CUSTOMER as cs
            inner join ORDERS as od on cs.CUST_CODE = od.CUST_CODE
        where
            od.ORDER_DATE between '2023-09-01' and '2023-09-31'
                group by
                    cs.CUST_CODE
                        having count(od.ORDER_NO) >= 5
                    order by
                        CNT desc,
                        AVG_AMT desc,
                        CODE asc
                            limit 5;