Changes between Version 11 and Version 12 of AdvancedReports

Timestamp:

01/09/23 21:48:57 (2 years ago)

Author:

201063

Comment:

--

AdvancedReports

@@ -2 +2 @@
 
 == Прашалник 1
-(text here)
+За секое прифатилиште, просечен број на посвојувачи кои се верификувани од 
+страна на вработени во тоа прифатилиште. 
 {{{#!sql
---sql here
+select 
+        shelter.id_shelter,
+        avg(adopters_verified)
+from 
+        shelter
+join
+        (
+                select
+                        employee.id_user as employee_id,
+                        employee.id_shelter as shelter_id,
+                        count(distinct adopter.id_user) as adopters_verified
+                from 
+                        employee
+                join adopter
+                        on adopter.verified_by_employee = employee.id_user
+                group by 
+                        employee.id_user
+        ) as q1
+        on q1.shelter_id = shelter.id_shelter 
+group by 
+        shelter.id_shelter 
+order by 
+        shelter.id_shelter asc
 }}}