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