SELECT CUSTOMER.CUST_CODE as CODE, CUSTOMER.CUST_NAME as NAME,count(CUSTOMER.CUST_CODE) as CNT
FROM CUSTOMER LEFT OUTER JOIN
(SELECT distinct ORDER_DATE,CUST_CODE from ORDERS where ORDER_DATE >='2023-07-01' and ORDER_DATE<='2023-07-31') ORDERS_1
on CUSTOMER.CUST_CODE = ORDERS_1.CUST_CODE
group by CUSTOMER.CUST_CODE,CUSTOMER.CUST_NAME
order by CNT DESC,CODE DESC