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