LEFT OUTER JOIN 조건절 배치

SELECT 
  A.SBJECT_CD, COUNT(B.USER_NO)
FROM 
  TB_SBJECT A
LEFT OUTER JOIN TB_USER B 
ON A.SBJECT_CD = B.SBJECT_CD
AND B.USER_GROUP = 'INSA'
--오른쪽 테이블은 ON 뒤 AND 에 조건 배치
WHERE
 A.SBJECT_LRN_BGNDE = '20191209'
--왼쪽 테이블은 WHERE절에 조건 배치
GROUP BY
  A.SBJECT_CD;