Changes between Version 15 and Version 16 of AdvancedReports

Timestamp:

03/05/23 00:37:40 (16 months ago)

Author:

201100

Comment:

--

AdvancedReports

@@ -84 +84 @@
 
 {{{
-select   qt.userid, 
-         q.quizname, 
-         avg(rt.points) 
-from quiztaker qt
+select distinct ut.username, q.quizname, avg(rt.points) from quiztaker qt
+join user_table ut on qt.userid = ut.userid 
 join attempt a on qt.userid= a.userid
 join quiz q on q.quizid=a.quizid
 join result_table rt  on a.attemptid=rt.attemptid
-group by 1, 2;
+group by 1, 2
+order by ut.username;
 }}}