SELECT C.CUST_CODE AS CODE , C.CUST_NAME AS NAME, COUNT(DISTINCT O.ORDER_DATE) AS CNT
FROM ORDERS O
INNER 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;