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