회원별 작성한 게시물 갯수 > ORACLE

• 목록

① select m.id , count(n.id) from member m INNER JOIN notice n ON m.id = n.writer group by m.id;

② select m.id , count(n.id) from member m LEFT OUTER JOIN notice n ON m.id = n.writer group by m.id;