with order_join AS (
    select *
    from customer c
    left outer join orders o
        on c.CUST_CODE = o.CUST_CODE
    where o.order_date >= '2023-09-01'
        AND o.order_date <= '2023-09-31'
    )
select CUST_CODE AS CODE
    , CUST_NAME AS NAME
    , COUNT(1) AS CNT
    , SUM(ORDER_AMNT) AS TTL_AMT
    , round(CAST(SUM(ORDER_AMNT) AS DOUBLE) / CAST(COUNT(1) AS DOUBLE), 0) AS AVG_AMT
from order_join
group by CUST_CODE, CUST_NAME
having CNT >= 5
order by CNT desc
    , AVG_AMT desc
    , CODE
limit 5;