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