SELECT OD.CUST_CODE AS CODE, CS.CUST_NAME AS NAME, COUNT (*) AS CNT
FROM ORDERS AS OD
 JOIN CUSTOMER AS CS
  ON OD.CUST_CODE = CS.CUST_CODE
WHERE OD.ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
GROUP BY CODE
ORDER BY CNT DESC, CODE DESC;