Changes between Version 13 and Version 14 of AdvancedReports

Timestamp:

02/10/23 13:51:30 (22 months ago)

Author:

201060

Comment:

--

AdvancedReports

@@ -74 +74 @@
 join attempt a on q.quizid=a.quizid
 where a.attemptdate between now() - interval '6 months' and now()
-group by 1
+group by 1, a.attemptdate
 order by count(a.attemptid)
 
@@ -104 +104 @@
 join quizTaker qt on at.userid  = qt.userid
 and at.attemptdate between now() - interval '3 months' and now()
+group by at.attemptdate
 }}}
 
@@ -128 +129 @@
 where s.choiceid=c.choiceid and c.iscorrect
 and a.attemptdate between now() - interval '1 year' and now()
-group by 1
+group by 1, a.attemptdate
 order by counter
 }}}
@@ -165 +166 @@
 on a.userid = q.userid 
 where a.attemptdate between now() - interval '1 year' and now()
-group by 1
+group by 1, a.attemptdate
 order by attempted_quizzes
 }}}
@@ -192 +193 @@
 where s.choiceid=c.choiceid and c.iscorrect
 and a.attemptdate between now() - interval '1 month' and now()
-group by 1
+group by 1, a.attemptdate
 order by counter
 }}}
@@ -208 +209 @@
 where a.attemptdate between now() - interval '3 months' and now()
 order by res.points desc
+group by a.attemptdate
 limit 5;
 }}}