1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
-- 코드를 입력하세요
With T AS (
Select T1.MEMBER_ID, MEMBER_NAME, REVIEW_TEXT, substring(REVIEW_DATE,1,10) as REVIEW_DATE
From MEMBER_PROFILE T1
Inner Join REST_REVIEW T2
ON T1.MEMBER_ID = T2.MEMBER_ID),
T3 AS (
Select *, ROW_NUMBER() OVER (PARTITION BY MEMBER_ID ORDER BY MEMBER_ID) as RN
From T)
Select MEMBER_NAME, REVIEW_TEXT,REVIEW_DATE
From T3 
Where MEMBER_ID IN (Select MEMBER_ID 
                    From T3 
                    Where RN = (Select MAX(RN) 
                                From T3))
Order By REVIEW_DATE, REVIEW_TEXT