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