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