Changes between Version 35 and Version 36 of AdvancedReports

Timestamp:

12/24/22 16:17:43 (2 years ago)

Author:

181006

Comment:

--

AdvancedReports

@@ -106 +106 @@
 select q4."location", q4.max_broj_nastani
 from (
-              (select extract (year from t.date) as godina,  count(distinct e.id_event) broj_nastani, t."location" 
-                from ticket t 
-                join events e  on t.id_event=e.id_event 
-                group by godina,  t."location" 
+
+(select extract (year from t.date) as godina,  count(distinct e.id_event) broj_nastani, t."location" 
+from ticket t 
+join events e on t.id_event=e.id_event 
+group by godina, t."location" 
+) q1
                 
-               ) q1
-                
-                join 
-                (
-                select max(q2.broj_nastani) as max_broj_nastani
-                from (
-                select extract (year from t.date) as godina,  count(distinct e.id_event) broj_nastani, t."location" 
-                from ticket t 
-                join events e  on t.id_event=e.id_event 
-                group by godina,  t."location"
-                ) q2
-                ) q3
-       on q1.broj_nastani=q3.max_broj_nastani) q4
+join 
+
+(
+select max(q2.broj_nastani) as max_broj_nastani
+from (
+select extract (year from t.date) as godina,  count(distinct e.id_event) broj_nastani, t."location" 
+from ticket t 
+join events e on t.id_event=e.id_event 
+group by godina, t."location"
+) q2 ) q3
+on q1.broj_nastani=q3.max_broj_nastani
+) 
+
+as q4
   }}}
 }}}
@@ -132 +135 @@
   {{{#!sql 
 select q4."name", q4.surname, q4.max_broj_nastani
-from(
+from (
 
 (select u."name", u.surname, count(e.id_event) as broj_nastani