select
    C.cust_code 'CODE'
    ,cust_name 'NAME'
    ,count(order_no) 'CNT'
    ,sum(order_amnt) 'TTL_AMT'
    ,round(sum(order_amnt)/count(order_no), 1) 'AVG_AMT'
from
    orders O
    left join customer C on C.cust_code=O.cust_code
where
    order_date between '2023-09-01' and '2023-09-30'
group by
    C.cust_code
having
    count(order_no) >= 5