Changes between Version 5 and Version 6 of AdvancedReports

Timestamp:

01/10/22 22:51:52 (3 years ago)

Author:

193140

Comment:

--

AdvancedReports

@@ -24 +24 @@
 
 == Најпопуларен наставник за секој предмет ==
+{{{#!sql
+select p.ime as predmet, n.ime as nastavnik, count(u.id_ucenik) as max_br
+from predmeti p 
+join predava_predmet pp on p.id_predmet = pp.id_predmet 
+join nastavnici n on pp.id_nastavnik = n.id_nastavnik 
+join predava_na pn on n.id_nastavnik = pn.id_nastavnik 
+join ucenici u on u.id_ucenik =pn.id_ucenik 
+where p.id_predmet = 1
+group by p.ime, n.ime
+limit 1
+}}}
+
+
+