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