SELECT CODE,
       NAME,
       COUNT(*) AS CNT
  FROM(SELECT O.CUST_CODE AS CODE,
              C.CUST_NAME AS NAME,
              COUNT(*) AS CNT
         FROM ORDERS O
         LEFT JOIN CUSTOMER C
           ON O.CUST_CODE = C.CUST_CODE
        WHERE O.ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
        GROUP BY O.CUST_CODE,
                 O.ORDER_DATE
       )
 GROUP BY CODE,
          NAME
 ORDER BY CNT DESC,
          CODE DESC