Changes between Version 11 and Version 12 of AdvancedReports

Timestamp:

01/12/22 02:00:07 (3 years ago)

Author:

193041

Comment:

--

AdvancedReports

@@ -108 +108 @@
 == Листа на наставници со број на одржани часови ==
 {{{#!sql
-select n.id_nastavnik , n.ime, count(c.id_cas) as max_br_casovi
+select n.id_nastavnik, n.ime, n.prezime, count(c.id_cas) as br_casovi
 from nastavnici n 
 left join casovi c on c.id_nastavnik = n.id_nastavnik 
-group by n.id_nastavnik , n.ime
-order by max_br_casovi desc
+group by n.id_nastavnik, n.ime
+order by br_casovi desc
 }}}