SELECT
OD.CUST_CODE AS CODE,
C.CUST_NAME AS NAME,
COUNT(OD.ORDER_NO) AS CNT,
SUM(OD.ORDER_AMNT) AS TTL_AMT,
ROUND(AVG(ORDER_AMNT),1) AS AVG_AMT

FROM ORDERS AS OD
 INNER JOIN CUSTOMER AS C
  ON OD.CUST_CODE = C.CUST_CODE
  
WHERE
 OD.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 ASC
 
 LIMIT 5;