Changes between Version 28 and Version 29 of AdvancedReports

Timestamp:

01/11/23 02:03:14 (2 years ago)

Author:

201088

Comment:

--

AdvancedReports

@@ -206 +206 @@
 from shelter s 
 join
-        (
-        select 
+       (
+       select 
                 e.id_user,
                 e.id_shelter,
                 count(distinct q1.id_user) as verified_adopters,
                 sum(q1.number_of_adoptions) as number_of_adoptions_under_employee
-        from
+       from
                 (
                 select 
@@ -222 +222 @@
                 group by a.id_user
                 ) q1
-        join employee e on e.id_user = q1.verified_by_employee
-        group by e.id_user
-        order by e.id_user asc
-        ) q2 on s.id_shelter = q2.id_shelter
+       join employee e on e.id_user = q1.verified_by_employee
+       group by e.id_user
+       order by e.id_user asc
+     ) q2 on s.id_shelter = q2.id_shelter
 join (
                 select
@@ -233 +233 @@
                 join employee e2 on e2.id_shelter = s.id_shelter 
                 group by s.id_shelter 
-        ) q3 on q3.id_shelter = s.id_shelter 
+     ) q3 on q3.id_shelter = s.id_shelter 
 group by s.id_shelter, q2.id_shelter, q3.number_of_employees,q2.verified_adopters, q2.number_of_adoptions_under_employee
 order by s.id_shelter