그룹별 조건에 맞는 식당 목록 출력하기

WITH TEST AS
(
SELECT M.MEMBER_NAME,R.MEMBER_ID,COUNT(R.MEMBER_ID) AS COUNTING
FROM MEMBER_PROFILE M JOIN REST_REVIEW R
ON M.MEMBER_ID=R.MEMBER_ID
GROUP BY R.MEMBER_ID,M.MEMBER_NAME
)
SELECT T.MEMBER_NAME,R.REVIEW_TEXT,TO_CHAR(R.REVIEW_DATE,'YYYY-MM-DD') AS REVIEW_DATE
FROM TEST T JOIN REST_REVIEW R
ON T.MEMBER_ID=R.MEMBER_ID
WHERE 
T.COUNTING IN (SELECT MAX(T.COUNTING) FROM TEST T)
ORDER BY R.REVIEW_DATE ASC,R.REVIEW_TEXT ASC;