Changes between Version 6 and Version 7 of AdvancedReports

Timestamp:

01/10/22 22:53:03 (3 years ago)

Author:

193140

Comment:

--

AdvancedReports

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