SELECT o.CUST_CODE AS CODE,
c.CUST_NAME AS NAME,
COUNT(DISTINCT o.ORDER_DATE) AS CNT
FROM ORDERS AS o
INNER JOIN CUSTOMER AS c
ON o.CUST_CODE=c.CUST_CODE
WHERE o.ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
GROUP BY o.CUST_CODE ,c.CUST_NAME

ORDER BY CNT DESC,CODE DESC;