with _all as (\r                                                                                 +
 select * from mc_case where create_date >='01.01.2017'\r                                         +
 )\r                                                                                              +
 , name_mo as (select short_name , po.id\r                                                        +
 from pim_organization po\r                                                                       +
 join _all on _all.clinic_id=po.id)\r                                                             +
 , res_count as (select count(template_res_group_id) res_count , _all.clinic_id\r                 +
 from _all\r                                                                                      +
 join mc_step ms on ms.case_id=_all.id\r                                                          +
 join sr_res_group srg on srg.id=ms.res_group_id\r                                                +
 GROUP BY _all.clinic_id\r                                                                        +
 )\r                                                                                              +
 ,protcol_count as (\r                                                                            +
 select count(msp.id) protcol_count , _all.clinic_id\r                                            +
 from _all\r                                                                                      +
 join md_srv_rendered msr on msr.case_id=_all.id\r                                                +
 join md_srv_protocol msp on msr.id=msp.srv_rendered_id\r                                         +
 GROUP BY _all.clinic_id\r                                                                        +
 )\r                                                                                              +
 \r                                                                                               +
 select distinct name_mo.short_name, res_count.res_count, protcol_count.protcol_count  from _all\r+
 join name_mo on _all.clinic_id=name_mo.id\r                                                      +
 join res_count on _all.clinic_id=res_count.clinic_id\r                                           +
 join protcol_count on _all.clinic_id=protcol_count.clinic_id\r