Changes between Version 5 and Version 6 of AdvancedReports

Timestamp:

01/11/22 00:46:24 (3 years ago)

Author:

183060

Comment:

--

AdvancedReports

@@ -41 +41 @@
 
 == Број на доктори во секој оддел
+
+
+{{{#!sql
+select o.bolnica_id, b.naziv as bolnica, b.grad as bolnica_grad,
+o.naziv as oddel, count (d.doktor_id) broj_doktori_vo_oddel
+from oddel o 
+join doktor d on (o.bolnica_id, o.oddel_id) = (d.bolnica_id, d.oddel_id)
+join bolnica b on o.bolnica_id = b.bolnica_id 
+group by (o.bolnica_id, o.oddel_id), b.naziv, b.grad 
+}}}