Changes between Version 32 and Version 33 of AdvancedReports

Timestamp:

12/24/22 16:05:23 (2 years ago)

Author:

181006

Comment:

--

AdvancedReports

@@ -173 +173 @@
 {{{#!div style="font-size: 90%"
   {{{#!sql 
-select c.id_user, r.rating, count(t.id_transaction) as broj_transakcii
+select u."name", u.surname, r.rating, count(t.id_transaction) as broj_transakcii
 from customer c 
 join review r on c.id_user=r.id_user_customer 
 join cart c2 on c.id_user=c2.id_user_customer 
 join transactions t on c2.id_user_customer=t.id_user_customer 
+join users u on c.id_user=u.id_user 
 where r.rating >7
-group by c.id_user, r.rating 
+group by u."name", u.surname, r.rating 
   }}}
 }}}