SELECT
      CODE
    , NAME
    , COUNT(*) AS CNT

FROM
(SELECT CUSTOMER.CUST_CODE AS CODE
    , CUST_NAME AS NAME
    , COUNT(*) AS CNTT
    FROM
    CUSTOMER
    INNER JOIN ORDERS 
        ON ORDERS.CUST_CODE = CUSTOMER.CUST_CODE 

WHERE  
    DATE(ORDER_DATE) BETWEEN '2023-07-01' AND '2023-07-31'
    GROUP BY CUSTOMER.CUST_CODE,CUST_NAME,ORDER_DATE
)
GROUP BY CODE,NAME
ORDER BY
        CNT  DESC
    ,   CODE DESC
    
;