with order_join AS (
    select *
    from customer c
    left outer join orders o
        on c.CUST_CODE = o.CUST_CODE
    where CAST(o.order_date AS timestamp) 
        BETWEEN CAST('2023-09-01' AS timestamp)
        AND CAST('2023-09-30' AS timestamp)
    )
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;