select o.CUST_CODE as CODE , c.CUST_NAME as NAME, COUNT(*) as CNT from ORDERS as o
inner join CUSTOMER as c
on o.CUST_CODE = c.CUST_CODE
group by o.CUST_CODE, o.ORDER_DATE
order by CNT desc, CODE desc