[프로그래머스/오라클] 그룹별 조건에 맞는 식당 목록 출력 - Oracle

 

SELECT M.MEMBER_NAME, R.REVIEW_TEXT, TO_CHAR(R.REVIEW_DATE, 'YYYY-MM-DD') AS REVIEW_DATE
FROM MEMBER_PROFILE M 
INNER JOIN REST_REVIEW R ON M.MEMBER_ID = R.MEMBER_ID
 
WHERE R.MEMBER_ID IN (
SELECT R.MEMBER_ID FROM REST_REVIEW R 
GROUP BY R.MEMBER_ID 
    
HAVING COUNT(*) = (SELECT MAX(COUNT(*))
    FROM REST_REVIEW 
    GROUP BY MEMBER_ID))
ORDER BY R.REVIEW_DATE, R.REVIEW_TEXT