select
    a.cust_code as "CODE",
    b.cust_name as "NAME",
    a.cnt as "CNT"

from(
    
    select
        cust_code,
        count(distinct order_date) as cnt
    from orders
    group by 1) as a
inner join customer as b
using(cust_code)
order by 3 desc, 1 desc