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 ORDERS.ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
GROUP BY
  ORDERS.CUST_CODE
ORDER BY
    CNT DESC
  , CODE DESC