Changes between Version 12 and Version 13 of AdvancedReports

Timestamp:

01/13/22 02:40:54 (3 years ago)

Author:

193041

Comment:

--

AdvancedReports

@@ -3 +3 @@
 {{{#!sql
 select p.ime as predmet, n.ime as ime_nastavnik, n.prezime as prezime_nastavnik, q3.ucenici as broj_ucenici
-
-from (
-                
-select * from (
+from 
+(               
+ select * from 
+ (
 
                 select broj_ucenici.predmet as predmet, max(broj_ucenici.ucenici) as ucenici 
@@ -21 +21 @@
                         as broj_ucenici 
                         group by broj_ucenici.predmet
-                        ) q1
+ ) q1
         
-                join (
+                join 
+                        (
                                 select p.id_predmet as predmet2, n.id_nastavnik, count(u.id_ucenik) as ucenici2
                                 from predmeti p 
@@ -31 +32 @@
                                 join ucenici u on u.id_ucenik =pn.id_ucenik 
                                 group by p.id_predmet, n.id_nastavnik 
-                                ) q2 
+                        ) q2 
                         on q2.predmet2 = q1.predmet and q2.ucenici2 = q1.ucenici