SELECT
    A.CODE
    ,A.NAME
    ,COUNT(A.CNT) as CNT
FROM
    (
    SELECT
	    C.CUST_CODE AS CODE
	    ,C.CUST_NAME AS NAME
	    ,O.ORDER_DATE
	    ,COUNT(ORDER_NO) AS CNT
    FROM ORDERS O
	    ,CUSTOMER C
    WHERE O.CUST_CODE = C.CUST_CODE
    AND O.ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
    GROUP BY C.CUST_CODE
	    	,C.CUST_NAME
		    ,O.ORDER_DATE
    ) A
GROUP BY A.CODE
        ,A.NAME
ORDER BY 3 DESC
        ,1 DESC
;