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