select O.CUST_CODE CODE
, C.CUST_NAME NAME
, count(distinct O.ORDER_DATE) CNT
from ORDERS O
     inner join CUSTOMER C
       on C.CUST_CODE = O.CUST_CODE
where O.ORDER_DATE >= '2023-07-01'
and O.ORDER_DATE <= '2023-07-31'
group by O.CUST_CODE
, C.CUST_NAME
order by CNT desc
, CODE desc