Changes between Version 45 and Version 46 of AdvancedReports

Timestamp:

12/24/22 17:21:47 (3 years ago)

Author:

181006

Comment:

--

AdvancedReports

@@ -110 +110 @@
         group by e.id_event 
 ) q1
+
 join 
 
@@ -145 +146 @@
         group by godina, t."location" 
 ) q1
+
 join 
 
@@ -170 +172 @@
   {{{#!sql 
 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
-
+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
+(
+        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) 
+on
+        q1.broj_nastani = q3.max_broj_nastani) 
 
 as q4