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 >= "2023-07-01"
AND o.ORDER_DATE <= "2023-07-31"
GROUP BY o.CUST_CODE
ORDER BY CNT DESC, CODE DESC;