SELECT * FROM
(SELECT A.CUST_CODE as CODE
,B.CUST_NAME as NAME
,COUNT(1) CNT 
FROM
( SELECT ORDER_DATE,CUST_CODE,COUNT(DISTINCT ORDER_DATE) CNT from ORDERS A WHERE ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31' 
GROUP BY ORDER_DATE,CUST_CODE
) A
 JOIN CUSTOMER B ON A.CUST_CODE= B.CUST_CODE
group by A.CUST_CODE,B.CUST_NAME
)
ORDER BY CNT DESC,CODE DESC