그룹별 조건에 맞는 식당 목록 출력하기1 JOIN>그룹별 조건에 맞는 식당 목록 출력하기 -- 코드를 입력하세요 select member_name, review_text, review_date from member_profile A join rest_review B on A.member_id = B.member_id where member_name like ( select /*member_id,*/ rank() over (order by count(member_id)) as cnt from rest_review group by member_id order by cnt desc ) -- select * from rest_review select member_id, rank() over (order by count(*)) as cnt from rest_review group by member_i.. 2023. 2. 26. 이전 1 다음 728x90