SELECT
    SUB.CUST_CODE AS CODE,
    CUST_NAME AS NAME,
    COUNT(CNT_NO) AS CNT
FROM (
    SELECT
        CUST_CODE,
        COUNT(ORDER_NO) AS CNT_NO
    FROM
        ORDERS
    WHERE
        ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
    GROUP BY
        CUST_CODE, ORDER_DATE
    ) AS SUB
    NATURAL JOIN CUSTOMER
GROUP BY
    CODE, NAME
ORDER BY
    CNT DESC,
    CODE DESC
;