WITH JULY AS (
SELECT
    CUST_CODE,
    DATE(ORDER_DATE) ORDER_DATE
FROM
    ORDERS
WHERE
    DATE(ORDER_DATE) BETWEEN '2023-07-01' AND '2023-07-31'
GROUP BY 1, 2
)
SELECT
    CUST_CODE CODE,
    CUST_NAME NAME,
    COUNT(ORDER_DATE)
FROM
    JULY
INNER JOIN CUSTOMER USING(CUST_CODE)
GROUP BY 1
ORDER BY
    3 DESC,
    1 DESC