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