Changes between Version 35 and Version 36 of AdvancedReports

Timestamp:

01/11/23 11:44:14 (2 years ago)

Author:

201088

Comment:

--

AdvancedReports

@@ -264 +264 @@
 select 
         o.name_organisation,
-        sum(q3.number_of_employees),
-        sum(q2.verified_adopters),
-        sum (q2.number_of_adoptions_under_employee)
+        sum(q3.number_of_employees) as number_of_employees,
+        sum(q2.verified_adopters) as verified_adopters,
+        sum (q2.number_of_adoptions_under_employee) as number_of_adoptions_under_employee
 from shelter s 
 join
@@ -299 +299 @@
         join organisation o on s.id_organisation = o.id_organisation 
 group by o.id_organisation 
-order by o.name_organisation  
+order by o.name_organisation
 }}}