with tmp as(
select distinct CUST_CODE,order_date from orders
where order_date between '2023-07-01' and '2023-07-31'
),
tmp2 as(
select CUST_CODE,count(*) as cnt from tmp
group by cust_code
)
select 
a.CUST_CODE as CODE,
b.CUST_NAME as NAME,
a.cnt as CNT
 from tmp2 as a
left join CUSTOMER as b
on a.CUST_CODE = b.CUST_CODE
order by a.cnt desc,a.cust_code desc


-- 表示項目CNTの降順
-- 表示項目CODEの降順