Changes between Version 27 and Version 28 of AdvancedReports

Timestamp:

01/11/23 01:59:38 (18 months ago)

Author:

201088

Comment:

--

AdvancedReports

@@ -274 +274 @@
 
 
+== Извештај 8
+Колку донации се направени за секоја организација
+{{{#!sql
+select o.name_organisation, 
+        count (d.id_user) as broj_donacii
+from organisation o 
+left join donor_donates_to_organisation ddto on o.id_organisation = ddto.id_organisation
+left join donor d on ddto.id_user = d.id_user
+group by o.id_organisation
+order by o.id_organisation 
+}}}
+
 [https://develop.finki.ukim.mk/projects/PAW5/wiki/WikiStart Назад кон почетна]