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