SELECT
 TBL1.CUST_CODE AS CODE
 , TBL2.CUST_NAME AS NAME
 , COUNT(TBL1.ORDER_NO) AS CNT
 , SUM(TBL1.ORDER_AMNT) AS TTL_AMT
 , ROUND(AVG(TBL1.ORDER_AMNT),0) AS AVG_AMT
FROM
 ORDERS TBL1
INNER JOIN
 CUSTOMER TBL2
ON
 TBL1.CUST_CODE = TBL2.CUST_CODE
WHERE
 TBL1.ORDER_DATE > '2023-09-00' AND TBL1.ORDER_DATE < '2023-09-99'
GROUP BY
 TBL1.CUST_CODE
HAVING
 COUNT(TBL1.ORDER_NO) > 4
ORDER BY
 COUNT(TBL1.ORDER_NO) DESC
 , AVG(TBL1.ORDER_AMNT) DESC
 , TBL1.CUST_CODE ASC
 LIMIT 5
;