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