SELECT
 o.CUST_CODE as CODE
,c.CUST_NAME as NAME
,count(*) as CNT
FROM ORDERS as o
LEFT JOIN CUSTOMER as c
ON o.CUST_CODE = c.CUST_CODE
WHERE ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
GROUP BY ORDER_DATE,o.CUST_CODE
ORDER BY count(*) desc ,o.CUST_CODE desc