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