Changes between Version 18 and Version 19 of AdvancedReports

Timestamp:

03/10/22 18:52:58 (2 years ago)

Author:

191151

Comment:

--

AdvancedReports

@@ -253 +253 @@
 }}}
 
-== Број на барања испратени кон артисти.
-
-{{{#!sql
-select 
-        a.user_id,
-        count(o.id) as num_of_offers_received 
+== Број на добиени барања за понуди по артист.
+
+{{{#!sql
+select 
+        u."name" ,
+        count(o.id) as num_of_offers_received 
 from artists a 
 join users u on u.id = a.user_id
 join offers o on o.artist_id = a.user_id 
 join events e on e.id = o.event_id
-group by a.user_id 
+group by u."name" 
 }}}