Changes between Version 25 and Version 26 of AdvancedReports

Timestamp:

01/11/23 01:17:46 (3 years ago)

Author:

201088

Comment:

--

AdvancedReports

@@ -197 +197 @@
 
 == Извештај 6
-(text here)
-{{{#!sql
---sql here
+Успешност на верификатори - број на верифицирани посвојувачи и вкупен број на посвојувања направени од посвојувачи за секој вработен-верификатор
+{{{#!sql
+select 
+        e.id_user,
+        count(distinct q1.id_user) as verified_adopters,
+        sum(q1.number_of_adoptions) as number_of_adoptions_under_employee
+from
+        (
+        select 
+                        a.id_user,
+                        a.verified_by_employee,
+                        count(distinct a2.id_adoption) as number_of_adoptions
+        from adopter a 
+        join adoption a2 on a.id_user = a2.id_adopter 
+        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
 }}}