Postgres 10

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

4 rows affected

visit_id	err_cd	err_name	m1_err_cnt
1	0	encoder	500
1	3	breakout	212
2	1	obclose	45
2	3	breakout	143

select 
  a.visit_id, 
  max(b.encoder_cnt) as encoder_cnt, 
  max(b.breakout_cnt) as breakout_cnt, 
  max(b.ob_close_cnt) as ob_close_cnt
from 
  tchn_visit_hist a
  left join(select 
              case when err_cd = '0' then m1_err_cnt end as encoder_cnt, 
              case when err_cd = '3' then m1_err_cnt end as breakout_cnt,
              case when err_cd = '1' then m1_err_cnt end as ob_close_cnt,
              case when err_cd = '0' then visit_id end as encoder_visit, 
              case when err_cd = '3' then visit_id end as breakout_visit,
              case when err_cd = '1' then visit_id end as ob_close_visit
            from
              tchn_visit_hist) b on case 
                                      when a.err_cd = '0' then a.visit_id = encoder_visit
                                      when a.err_cd = '3' then a.visit_id = breakout_visit
                                      when a.err_cd = '1' then a.visit_id = ob_close_visit
                                     end
group by
   a.visit_id
order by
   a.visit_id asc

visit_id	encoder_cnt	breakout_cnt	ob_close_cnt
1	500	212	null
2	null	143	45