[SQL] 최다수 WHERE Subquery 활용

SELECT 

*

FROM MEMBER_PROFILE   
INNER JOIN REST_REVIEW ON MEMBER_PROFILE.MEMBER_ID=REST_REVIEW.MEMBER_ID 
WHERE MEMBER_PROFILE.MEMBER_ID = (
    SELECT MEMBER_ID
    FROM REST_REVIEW
    GROUP BY MEMBER_ID 
    ORDER BY COUNT(*) DESC
		→ COUNT 다수 내림차순
    LIMIT 1
		→ 갯수 표기
)