SELECT *
  FROM (SELECT COUNT(DECODE(attend_kind, '1', 1)) AS cnt_chulsuk
             , COUNT(DECODE(attend_kind, '0', 1)) AS cnt_gyeolsuk
             , COUNT(DECODE(attend_kind, '2', 1)) AS cnt_chungga
             , COUNT(DECODE(attend_kind, '3', 1)) AS cnt_chuljang
             , COUNT(DECODE(attend_kind, '4', 1)) AS cnt_gyeolsuk2
          FROM ap_current_mgr cm
         INNER JOIN ap_attendance at
            ON cm.session_cd    = at.session_cd
           AND cm.currents_cd   = at.currents_cd
           AND cm.currents_kind = at.currents_kind
        ) a
     , (SELECT COUNT(*) AS cnt_jaejeak  -- 재적 의원수
          FROM ap_member
         WHERE mem_state = '1'
        ) b
     , (SELECT SUM( NVL(chk_1, 0)
                  + NVL(chk_2, 0)
                  + NVL(chk_3, 0)
                  + NVL(chk_4, 0)
                  + NVL(chk_5, 0)
                  + NVL(chk_6, 0)
                  + NVL(chk_7, 0)
                  + NVL(chk_8, 0)
                  + NVL(chk_9, 0)
                  ) AS cnt_jaesuk -- 재석 인원 수
          FROM ap_current_mgr cm
         INNER JOIN
               (SELECT session_cd, currents_cd, currents_kind
                     , ROW_NUMBER() OVER(
                       PARTITION BY session_cd, currents_cd, currents_kind
                       ORDER BY seq_no DESC
                       ) AS rn
                     , chk_1, chk_2, chk_3, chk_4, chk_5, chk_6, chk_7, chk_8, chk_9
                  FROM ap_manual_seat_chk_cnt
                ) at
            ON at.session_cd    = cm.session_cd
           AND at.currents_cd   = cm.currents_cd
           AND at.currents_kind = cm.currents_kind
           AND at.rn = 1
        ) c
;