[SQL문제풀기] 그룹별 조건에 맞는 식당 목록 출력하기

문제

MYSQL

내가 작성한 오답

SELECT M.MEMBER_NAME, R.REVIEW_TEXT, R.REVIEW_DATE
FROM MEMBER_PROFILE M
JOIN REST_REVIEW R ON R.MEMBER_ID = M.MEMBER_ID 
WHERE M.MEMBER IN ( SELECT MEMBER_ID
                    FROM REST_REVIEW
                    GROUP BY MEMBER_ID
                    ORDER BY COUNT(REVIEW_ID) DESC
                    LIMIT 1)
ORDER BY 3, 2;

내가 작성한 정답

SELECT M.MEMBER_NAME, R.REVIEW_TEXT, DATE_FORMAT(R.REVIEW_DATE,'%Y-%m-%d') REVIEW_DATE
FROM MEMBER_PROFILE M
JOIN REST_REVIEW R ON R.MEMBER_ID = M.MEMBER_ID 
WHERE M.MEMBER_ID = ( 
    SELECT MEMBER_ID
    FROM REST_REVIEW
    GROUP BY MEMBER_ID
    ORDER BY COUNT(REVIEW_ID) DESC
    LIMIT 1
) 
ORDER BY 3, 2;

ORACLE

내가 작성한 정답

SELECT M.MEMBER_NAME, R.REVIEW_TEXT, TO_CHAR(R.REVIEW_DATE,'YYYY-MM-DD') REVIEW_DATE
FROM MEMBER_PROFILE M
JOIN REST_REVIEW R ON M.MEMBER_ID = R.MEMBER_ID
WHERE M.MEMBER_ID IN (SELECT MEMBER_ID
                        FROM REST_REVIEW
                        GROUP BY MEMBER_ID
                        ORDER BY COUNT(REVIEW_ID) DESC
                        FETCH FIRST 1 ROWS ONLY)
ORDER BY 3, 2;