Changes between Version 49 and Version 50 of AdvancedReports

Timestamp:

12/24/22 17:39:58 (3 years ago)

Author:

181006

Comment:

--

AdvancedReports

@@ -163 +163 @@
 }}}
 
+OR
+
+{{{#!div style="font-size: 90%"
+  {{{#!sql 
+select q4.godina, q4.city, q4.max_broj_nastani
+from    (
+(
+        select extract (year from e."date") as godina,
+                count(distinct e.id_event) broj_nastani, e.city
+        from events e
+        group by godina, e.city 
+) q1
+
+join 
+
+(
+        select max(q2.broj_nastani) as max_broj_nastani
+        from
+                (
+                select extract (year from e."date") as godina,
+                        count(distinct e.id_event) broj_nastani, e.city
+                from events e
+                group by godina, e.city 
+) q2 ) q3
+on
+        q1.broj_nastani = q3.max_broj_nastani) 
+as q4
+  }}}
+}}}
+
 == Артист со максимален број на одржани настани