select
    C.CUST_CODE AS CODE,
    C.CUST_NAME AS NAME,
    COUNT(O.ORDER_NO) AS CNT
FROM
    CUSTOMER AS C

LEFT JOIN ORDERS AS O
ON O.CUST_CODE=C.CUST_CODE
WHERE O.ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'

GROUP BY C.CUST_CODE;