SELECT CODE,
NAME,
COUNT(ORD_DATE) as CNT

FROM 
(SELECT DISTINCT CUS.CUST_CODE as CODE,CUS.CUST_NAME as NAME, OD.ORDER_DATE  as ORD_DATE FROM 

ORDERS OD inner join CUSTOMER CUS
ON OD.CUST_CODE = CUS.CUST_CODE
WHERE OD.ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
)
--WHERE 
-- OD.ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
GROUP BY CODE,NAME
ORDER BY CNT desc, CODE desc