SELECT
O.CUST_CODE AS CODE
,C.CUST_NAME AS NAME
,COUNT(DISTINCT O.ORDER_DATE) AS CNT

FROM ORDERS AS O

INNER JOIN CUSTOMER AS C
ON O.CUST_CODE = C.CUST_CODE

WHERE ORDER_DATE BETWEEN "2023-07-01" AND "2023-07-31"

GROUP BY
O.CUST_CODE
,C.CUST_NAME

ORDER BY
CNT DESC,
CODE DESC;