Changes between Version 18 and Version 19 of AdvancedReports

Timestamp:

12/20/22 15:02:30 (2 years ago)

Author:

191285

Comment:

--

AdvancedReports

@@ -96 +96 @@
   }}}
 }}}
+== Број на трансакции реализирани од страна на купувачи кои оставиле позитивни рецензии (оценка над 3) кон артисти 
+
+{{{#!div style="font-size: 90%"
+  {{{#!sql 
+select count (*) from (
+with tempTable as (select 
+        o.* 
+from organizers o 
+join reviews as r on 
+       r.organizer_id = o.user_id and 
+       r.rating > 3
+group by o.user_id)
+select 
+        t.*
+from events as e
+join tempTable as tt on 
+       tt.user_id = e.organizer_id 
+join offers as o2 on 
+       o2.event_id = e.id 
+join transactions as t on 
+     t.offer_id = o2.id 
+) as temp
+  }}}
+}}}
 == Настан со најмногу заинтересирани купувачи во последните 100 дена 
 
@@ -140 +164 @@
 
 
-== Број на трансакции реализирани од страна на купувачи кои оставиле позитивни рецензии (оценка над 3) кон артисти 
-
-{{{#!div style="font-size: 90%"
-  {{{#!sql 
-select count (*) from (
-with tempTable as (select 
-        o.* 
-from organizers o 
-join reviews as r on 
-       r.organizer_id = o.user_id and 
-       r.rating > 3
-group by o.user_id)
-select 
-        t.*
-from events as e
-join tempTable as tt on 
-       tt.user_id = e.organizer_id 
-join offers as o2 on 
-       o2.event_id = e.id 
-join transactions as t on 
-     t.offer_id = o2.id 
-) as temp
-  }}}
-}}}