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

문제

MYSQL

작성한 정답

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 R.MEMBER_ID IN (
                    SELECT MEMBER_ID 
                    FROM (SELECT MEMBER_ID, COUNT(REVIEW_ID) N
                            FROM REST_REVIEW
                            GROUP BY MEMBER_ID
                            ORDER BY N DESC
                            LIMIT 1) AS MEM
                  ) 
ORDER BY REVIEW_DATE ASC,REVIEW_TEXT ASC;

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 R.MEMBER_ID = M.MEMBER_ID
WHERE R.MEMBER_ID IN (
                    SELECT MEMBER_ID 
                    FROM (SELECT MEMBER_ID, COUNT(REVIEW_ID) N
                            FROM REST_REVIEW
                            GROUP BY MEMBER_ID
                            ORDER BY N DESC)
                    WHERE ROWNUM = 1
                  ) 
ORDER BY REVIEW_DATE ASC,REVIEW_TEXT ASC