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