SELECT CODE,NAME,COUNT(*) as CNT FROM 
(SELECT
 c.CUST_CODE as  CODE
 ,CUST_NAME as  NAME
--  ,COUNT(ORDER_DATE) as  CNT
 ,ORDER_DATE
FROM
 ORDERS as o inner join CUSTOMER as c on o.CUST_CODE = c.CUST_CODE
 -- and o.EMP_CODE = c.EMP_CODE
where 
 ORDER_DATE between '2023-07-01' and '2023-07-31'
GROUP BY 
 CODE,NAME,ORDER_DATE
) 
GROUP BY
 CODE,NAME
ORDER BY 
 CNT desc
 ,CODE desc
 ;