select
CUSTOMER.CUST_CODE as CODE,
CUSTOMER.CUST_NAME as NAME,
count(DISTINCT ORDERS.CUST_CODE || ORDER_DATE) as CNT
from ORDERS
inner join CUSTOMER
ON ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
where ORDER_DATE between '2023-07-01' and '2023-07-31'
group by CODE
order by CNT DESC, CODE DESC;