--【問題9】
SELECT
	A.CUST_CODE AS CODE
,	B.CUST_NAME AS NAME
,	COUNT(DISTINCT A.ORDER_DATE) AS CNT
FROM
	ORDERS A
,	CUSTOMER B
WHERE
	A.CUST_CODE = B.CUST_CODE
AND	A.ORDER_DATE >= '2023-07-01'
AND	A.ORDER_DATE <= '2023-07-31'
GROUP BY
	A.CUST_CODE
,	B.CUST_NAME
ORDER BY
	CNT DESC
,	CODE DESC