Changes between Version 20 and Version 21 of AdvancedReports

Timestamp:

12/23/22 18:49:59 (2 years ago)

Author:

191285

Comment:

--

AdvancedReports

@@ -139 +139 @@
 {{{#!div style="font-size: 90%"
   {{{#!sql 
-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 
-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
-order by br_ucenici desc
+select u."name", u.surname, count(e.id_event) as broj_nastani 
+from artist a join users u on a.id_user =u.id_user
+join events e on a.id_user =e.id_user_artist
+where u.id_user in (
+select u.id_user 
+from artist a join users u on a.id_user =u.id_user
+join events e on a.id_user =e.id_user_artist
+where e.id_event =1
+group by  u.id_user )
+group by  u."name", u.surname
   }}}
 }}}