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