SELECT
 o.CUST_CODE as CODE
,c.CUST_NAME as NAME
,count(distinct ORDER_DATE) as CNT
FROM ORDERS as o
LEFT JOIN CUSTOMER as c
ON o.CUST_CODE = c.CUST_CODE
WHERE ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
GROUP BY CODE,NAME
ORDER BY CNT desc ,CODE desc