문제 링크 : https://school.programmers.co.kr/learn/courses/30/lessons/131124 정상 코드. 방법 1 윈도우 함수사용. 리뷰 많이 쓴 MEMBER_ID 찾기 SELECT MEMBER_NAME, REVIEW_TEXT, DATE_FORMAT(REVIEW_DATE,'%Y-%m-%d') AS REVIEW_DATE FROM MEMBER_PROFILE JOIN REST_REVIEW USING (MEMBER_ID) WHERE MEMBER_ID IN (SELECT MEMBER_ID FROM (SELECT *, DENSE_RANK() OVER (ORDER BY COUNT(*) DESC) AS REVIEW_RANK FROM REST_REVIEW GROUP BY MEMBER..
