SELECT CODE, C.CUST_NAME AS NAME, CNT
FROM (
    
    SELECT CUST_CODE AS CODE, 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
    )
    GROUP BY CUST_CODE
)
JOIN 
CUSTOMER AS C
ON (CODE = C.CUST_CODE)
ORDER BY
CNT DESC, CODE DESC