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