SELECT 
CUSTOMER.CUST_CODE as CODE,
CUST_NAME as NAME,
count(case when ORDER_DATE>='2023-07-01' and ORDER_DATE<='2023-07-31' 
     then ORDERS.CUST_CODE else 0 end) as CNT
FROM
CUSTOMER left outer join ORDERS  ON  CUSTOMER.CUST_CODE= ORDERS.CUST_CODE




GROUP BY ORDERS.CUST_CODE 
having ORDER_DATE


ORDER BY
CNT DESC,
CODE  ASC;