SELECT CUST_CODE AS CODE, CUST_NAME AS NAME, COUNT(DISTINCT ORDER_DATE) AS CNT
FROM CUSTOMER JOIN ORDERS USING (CUST_CODE) WHERE ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31' GROUP BY CUST_CODE ORDER BY 3 DESC, 1 DESC;