Problems trying to read a JSONB column about postgres-nio HOT 10 CLOSED

drop view if exists work_assignment_view;
create view work_assignment_view as
select 
  tm.team_member_id as team_member_id, 
  tm.job_title as job_title, 
  tm.first_name || ' ' || tm.last_name as assignee, 
  (
    select 
      count(patient_room.id) 
    from 
      patient_room, 
      nursing_team
    where 
      patient_room.room_number = nursing_team.room_number 
      and (
        tm.team_member_id = nursing_team.nurse_id 
        or tm.team_member_id = nursing_team.assistant_id
      )
  ) as room_count, 
  (
    select 
      case when count(patient_room.id) > 0 then true else false end 
    from 
      patient_room, 
      nursing_team
    where 
      patient_room.room_number = nursing_team.room_number 
      and (
        tm.team_member_id = nursing_team.nurse_id 
        or tm.team_member_id = nursing_team.assistant_id
      )
  ) as has_assignment, 
  (
    select 
      coalesce(jsonb_agg(patient_room.room_number) filter(where patient_room.room_number is not null), '[]')
    from 
      patient_room, 
      nursing_team
    where 
      patient_room.room_number = nursing_team.room_number 
      and (
        tm.team_member_id = nursing_team.nurse_id 
        or tm.team_member_id = nursing_team.assistant_id
      )
  ) as rooms, 
  (
    select unit_telephone.telephone_number
    from
      unit_telephone
    where
      unit_telephone.team_member_id = tm.team_member_id
  ) as unit_telephone,
  row_number() over () as id 
from 
  team_member tm, 
  work_availability wa
where 
  tm.team_member_id = wa.team_member_id 
  and wa.is_on_shift = true 
group by 
  tm.id;