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