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

;