SELECT
    ORDERS.CUST_CODE            AS CODE
    , CUST_NAME                 AS NAME
    , COUNT(ORDER_NO)           AS CNT
    , SUM(ORDER_AMNT)           AS TTL_AMT
    , ROUND(AVG(ORDER_AMNT), 0) AS AVG_AMT
FROM
    ORDERS
    LEFT JOIN CUSTOMER ON
    	ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
WHERE
    1=1
    AND ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
GROUP BY
    CODE, NAME
HAVING
    CNT >= 5
ORDER BY
    CNT DESC
    , AVG_AMT DESC
    , CODE
LIMIT 5
;