select
    C.CUST_CODE as CODE,
    C.CUST_NAME as NAME,
    count(*) as CNT,
    sum(O.ORDER_AMNT) as TTL_AMT,
    round(cast (sum(O.ORDER_AMNT) as REAL) / count(*), 0) as AVG_AMT
from
    CUSTOMER as C,
    ORDERS as O
where
    "2023-09-01" <= O.ORDER_DATE
    and O.ORDER_DATE < "2023-10-01"
    and O.CUST_CODE == C.CUST_CODE
group by
    O.CUST_CODE,
    C.CUST_CODE
having
    CNT >= 5
order by
    CNT desc,
    AVG_AMT desc,
    CODE