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) ORDERS_1
on CUSTOMER.CUST_CODE = ORDERS_1.CUST_CODE
group by CUSTOMER.CUST_CODE,CUSTOMER.CUST_NAME
order by CNT,CODE DESC