SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
WITH CTE as ( select tt."moid",tt."moname",tt."regionid",tt."regionname", sum(Count) count from ( Select mo."Id" as MOId,mo."Name" as MOName, r."Id" as RegionId, r."Name" as RegionName ,count(adr."MedicalId") as Count from public."AnketaAmbulatorResult" adr join public."MedicalOrgs" as mo on mo."Id" = adr."MedicalId" join public."Regions" r on r."Id" = mo."RegionId" where adr."Created" between '2022-11-12' and '2022-12-07' group by mo."Id", mo."Name", r."Id" , r."Name" union all Select mo."Id" as MOId, mo."Name" as MOName, r."Id" as RegionId, r."Name" as RegionName , count(adr."MedicalId" ) as Count from public."AnketaStacionarResult" adr join public."MedicalOrgs" as mo on mo."Id" = adr."MedicalId" join public."Regions" r on r."Id" = mo."RegionId" where adr."Created" between '2022-11-12' and '2022-12-07' group by mo."Id", mo."Name", r."Id" , r."Name" union all Select mo."Id" as MOId, mo."Name" as MOName, r."Id" as RegionId, r."Name" as RegionName , count(adr."MedicalId" ) as Count from public."AnketaSanatoriaResult" adr join public."MedicalOrgs" as mo on mo."Id" = adr."MedicalId" join public."Regions" r on r."Id" = mo."RegionId" where adr."Created" between '2022-11-12' and '2022-12-07' group by mo."Id", mo."Name", r."Id" , r."Name" union all Select mo."Id" as MOId, mo."Name" as MOName, r."Id" as RegionId, r."Name" as RegionName , count(adr."MedicalId" ) as Count from public."AnketaPsychiatricResult" adr join public."MedicalOrgs" as mo on mo."Id" = adr."MedicalId" join public."Regions" r on r."Id" = mo."RegionId" where adr."Created" between '2022-11-12' and '2022-12-07' group by mo."Id", mo."Name", r."Id" , r."Name") tt group by tt."moid", tt."moname", tt."regionid", tt."regionname" ) , CTE2 as ( select tg."moid",tg."moname",tg."regionid",tg."regionname", sum(Count) count2 from ( Select mo."Id" as MOId,mo."Name" as MOName, r."Id" as RegionId, r."Name" as RegionName ,count(adr."MedicalId") as Count from public."AnketaAmbulatorResult" adr join public."MedicalOrgs" as mo on mo."Id" = adr."MedicalId" join public."Regions" r on r."Id" = mo."RegionId" where adr."Created" between '2022-11-12' and '2022-12-07' and "QualityType" = 2 group by mo."Id", mo."Name", r."Id" , r."Name" union all Select mo."Id" as MOId, mo."Name" as MOName, r."Id" as RegionId, r."Name" as RegionName , count(adr."MedicalId" ) as Count from public."AnketaStacionarResult" adr join public."MedicalOrgs" as mo on mo."Id" = adr."MedicalId" join public."Regions" r on r."Id" = mo."RegionId" where adr."Created" between '2022-11-12' and '2022-12-07' and "QualityType" = 2 group by mo."Id", mo."Name", r."Id" , r."Name" union all Select mo."Id" as MOId, mo."Name" as MOName, r."Id" as RegionId, r."Name" as RegionName , count(adr."MedicalId" ) as Count from public."AnketaSanatoriaResult" adr join public."MedicalOrgs" as mo on mo."Id" = adr."MedicalId" join public."Regions" r on r."Id" = mo."RegionId" where adr."Created" between '2022-11-12' and '2022-12-07' and "QualityType" = 2 group by mo."Id", mo."Name", r."Id" , r."Name" union all Select mo."Id" as MOId, mo."Name" as MOName, r."Id" as RegionId, r."Name" as RegionName , count(adr."MedicalId" ) as Count from public."AnketaPsychiatricResult" adr join public."MedicalOrgs" as mo on mo."Id" = adr."MedicalId" join public."Regions" r on r."Id" = mo."RegionId" where adr."Created" between '2022-11-12' and '2022-12-07' and "QualityType" = 2 group by mo."Id", mo."Name", r."Id" , r."Name") tg group by tg."moid",tg."moname",tg."regionid",tg."regionname" ) Select * from cte2
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear