Changes between Version 19 and Version 20 of AdvancedReports

Timestamp:

12/23/22 12:25:20 (2 years ago)

Author:

191285

Comment:

--

AdvancedReports

@@ -151 +151 @@
 }}}
 
-== Листа на артисти со број на одржани настани 
+== Артист со максимален број на одржани настани 
 
 {{{#!div style="font-size: 90%"
   {{{#!sql 
-select p.ime as predmet, count(pp.id_nastavnik) broj_na_nastavnici
-from predmeti p
-join predava_predmet pp on pp.id_predmet = p.id_predmet 
-group by p.id_predmet 
-order by p.ime;
+select q4."name", q4.surname, q4.max_broj_nastani
+from
+(
+
+(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 
+group by  u."name", u.surname) q1
+
+join
+
+(select max(q2.broj_nastani) as max_broj_nastani
+from (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 
+group by  u."name", u.surname
+) q2 ) q3
+on q1.broj_nastani=q3.max_broj_nastani) 
+
+as q4
   }}}
 }}}