SELECT
    CUSTOMER.CUST_CODE as CODE
  , CUSTOMER.CUST_NAME as NAME
  , COUNT(distinct ORDERS.ORDER_DATE) as CNT
FROM ORDERS
LEFT JOIN CUSTOMER
   ON ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
WHERE ORDER_DATE BETWEEN '2023-07-01 00:00:00' AND '2023-07-31 23:59:59'
GROUP BY
  ORDERS.CUST_CODE
ORDER BY
    CNT DESC
  , CODE DESC