WITH OD AS (
SELECT CUST_CODE,ORDER_DATE,COUNT(*)
FROM ORDERS
WHERE ORDER_DATE >= '2023-07-01'
AND ORDER_DATE <= '2023-07-31'
GROUP BY CUST_CODE,ORDER_DATE
)
SELECT OD.CUST_CODE AS CODE,CS.CUST_NAME AS NAME,COUNT(*) AS CNT
FROM OD
INNER JOIN CUSTOMER CS
ON OD.CUST_CODE = CS.CUST_CODE
GROUP BY OD.CUST_CODE,CS.CUST_NAME
ORDER BY CNT DESC,CODE DESC;