SELECT A.CUST_CODE AS CODE,
A.CUST_NAME AS NAME,
COUNT(distinct B.ORDER_DATE) AS CNT FROM CUSTOMER AS A,ORDERS AS B WHERE "2023-07-01" <= B.ORDER_DATE AND B.ORDER_DATE <= "2023-07-31" AND A.CUST_CODE == B.CUST_CODE GROUP BY A.CUST_CODE ORDER BY CNT DESC,CODE DESC;