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