for select tu.phys_id, tu.code_spec, z(sum(tu.k_uslf)) as k_uslf
   from list_usl tu
   where tu.rf_case_id in (select tc.list_cases_id from list_cases tc where tc.target in (1,2,3,4,5,20)and tc.q_u=2
                           and (:r_str like '%,'||trim(cast(tc.rf_reestr_id as varchar(20)))||',%') )
   group by 1,2
  into :vr_fio, :vr_spec, :pos  do
  begin
    select z(count(*)) from list_cases tc
     where (:r_str like '%,'||trim(cast(tc.rf_reestr_id as varchar(20)))||',%')
      and tc.q_u=2 and tc.target in (1,2,3,4,5,20) and tc.phys_id=:vr_fio and tc.code_spec=:vr_spec
    into :kol;
    suspend;
  end

select ..., count(distinct master.id), count(*) from master join detail on ...
group by ....

select t.vr_fio, t.vr_spec
  , sum(iif(t.tip='OMS',t.count_case,0)) as OMS_cases
  , sum(iif(t.tip='OMS',t.count_pos,0)) as OMS_pos
  , sum(iif(t.tip='PROF',t.count_case,0)) as PROF_cases
  , sum(iif(t.tip='PROF',t.count_pos,0)) as PROF_pos
  , sum(iif(t.tip='PROF',t.count_usl,0)) as PROF_usl
  , sum(iif(t.tip='CZ',t.count_case,0)) as CZ_cases
  , sum(iif(t.tip='CZ',t.count_pos,0)) as CZ_pos
  , sum(iif(t.tip='DD',t.count_case,0)) as DD_cases
  , sum(iif(t.tip='DD',t.count_pos,0)) as DD_pos
  , sum(iif(t.tip='DD',t.count_usl,0)) as DD_usl
  , sum(iif(t.tip='MTR',t.count_case,0)) as MTR_cases
  , sum(iif(t.tip='MTR',t.count_pos,0)) as MTR_pos
  , sum(iif(t.tip='MTR',t.count_usl,0)) as MTR_usl
  , sum(iif(t.tip='NI',t.count_case,0)) as NI_cases
  , sum(iif(t.tip='NI',t.count_pos,0)) as NI_pos
  , sum(iif(t.tip='NI',t.count_usl,0)) as NI_usl
  from prev_rep_sch_vr(:year_otch,:month_otch) t
  group by 1, 2