WITH t1 AS(
SELECT
    CUST_CODE
    ,COUNT(DISTINCT ORDER_DATE) AS CNT
FROM
    ORDERS
WHERE

    ORDER_DATE >= '2023-07-01' AND ORDER_DATE <= '2023-07-31' 
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