WITH t1 AS(
SELECT
    CUST_CODE
    ,COUNT(*) AS CNT
FROM
    ORDERS
WHERE
    datetime(ORDER_DATE, 'start of month') = '2023-07-01 00:00:00'
GROUP BY
    CUST_CODE
)
SELECT
    t1.CUST_CODE AS CODE
    ,CUSTOMER.CUST_NAME AS NAME
    ,t1.CNT AS CNT
FROM
    t1
    INNER JOIN
        CUSTOMER
        ON CUSTOMER.CUST_CODE = t1.CUST_CODE
ORDER BY
    t1.CNT DESC
    ,CUSTOMER.CUST_NAME DESC