Changes between Version 10 and Version 11 of AdvancedReports

Timestamp:

12/20/22 14:20:16 (2 years ago)

Author:

191285

Comment:

--

AdvancedReports

@@ -12 +12 @@
 {{{#!div style="font-size: 90%"
   {{{#!sql 
-
+select p.ime as predmet, count(zz.id_ucenik) as broj_na_zainteresirani_ucenici
+from predmeti p 
+join zainteresiran_za zz 
+on zz.id_predmet = p.id_predmet 
+join ucenici u 
+on u.id_ucenik = zz.id_ucenik 
+where zz.datum between current_date - interval '100 days' and current_date
+group by p.ime
+order by count(zz.id_ucenik) desc 
+limit 1;
   }}}
 }}}