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