select
    CU.cust_code as CODE
    , CU.cust_name as NAME
    , o.c as CNT
from customer as CU
    right join (select cust_code,count(order_no) c from orders group by cust_code) o
    on o.cust_code = CODE
order by
    CNT desc,
    CODE desc