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