SELECT
    ord.CUST_CODE AS CODE
    ,cus.CUST_NAME AS NAME
    ,COUNT(ORDER_NO) AS CNT
    ,SUM(ORDER_AMNT) AS TTL_AMT
    ,ROUND(SUM(ORDER_AMNT) / CAST(COUNT(ORDER_NO) AS double) ,0)AS AVG_AMT
FROM
    ORDERS AS ord
LEFT JOIN
    CUSTOMER AS cus
ON 
    ord.CUST_CODE = cus.CUST_CODE
WHERE
    ord.ORDER_DATE between date ('2023-09-01') and date ('2023-09-31')
GROUP BY
    1,2
HAVING
    CNT > 4
ORDER BY
    3 DESC,5 DESC , 1 ASC