SELECT
B.MEMBER_NAME,
A.REVIEW_TEXT,
DATE_FORMAT(A.REVIEW_DATE, '%Y-%m-%d') REVIEW_DATE
FROM REST_REVIEW A
LEFT JOIN MEMBER_PROFILE B USING (MEMBER_ID)
WHERE MEMBER_ID = ( SELECT MEMBER_ID
FROM REST_REVIEW
GROUP BY MEMBER_ID
ORDER BY COUNT(REVIEW_ID) DESC
LIMIT 1 )
ORDER BY A.REVIEW_DATE, A.REVIEW_TEXT;
1.date_format 형식
'%Y-%m-%d' => 2023-06-30 형식