Changes between Version 7 and Version 8 of AdvancedReports

Timestamp:

01/10/22 22:55:10 (3 years ago)

Author:

193140

Comment:

--

AdvancedReports

@@ -37 +37 @@
 }}}
 
+== Наставник со најголем број одржани часови ==
+{{{#!sql
+select n.id_nastavnik , n.ime, count(c.id_cas) as max_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
+limit 1
+}}}