1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
WITH most_reviews AS(
    SELECT 
            member_id,
            count(*) AS reviews
    FROM
            rest_review r

    GROUP BY
            member_id
    ORDER BY 
            reviews DESC
    LIMIT 1
)

SELECT 
        m.member_name,
        r.review_text,
        DATE_FORMAT(r.review_date, '%Y-%m-%d') AS review_date
FROM
        most_reviews mr
INNER JOIN 
        member_profile m
ON 
        mr.member_id = m.member_id
INNER JOIN
        rest_review r
ON 
        m.member_id = r.member_id
ORDER BY 
        review_date, review_text