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