SELECT
    CODE,
    NAME,
    COUNT(*) AS CNT
FROM (
    SELECT DISTINCT
        CUST_CODE AS CODE,
        CUST_NAME AS NAME,
        ORDER_DATE
    FROM
        ORDERS
    INNER JOIN
        CUSTOMER USING (CUST_CODE)
    WHERE
        ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
)
GROUP BY
    CODE
ORDER BY
    CNT DESC,
    CODE DESC
;