Changes between Version 29 and Version 30 of AdvancedReports

Timestamp:

01/11/23 02:05:55 (18 months ago)

Author:

201088

Comment:

--

AdvancedReports

@@ -227 +227 @@
      ) q2 on s.id_shelter = q2.id_shelter
 join (
-                select
-                        s.id_shelter,
-                        count(distinct e2.id_user) as number_of_employees
-                from shelter s 
-                join employee e2 on e2.id_shelter = s.id_shelter 
-                group by s.id_shelter 
+        select
+                s.id_shelter,
+                count(distinct e2.id_user) as number_of_employees
+        from shelter s 
+        join employee e2 on e2.id_shelter = s.id_shelter 
+        group by 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