Changes between Version 9 and Version 10 of AdvancedReports

Timestamp:

01/28/23 18:24:32 (22 months ago)

Author:

201100

Comment:

--

AdvancedReports

@@ -195 +195 @@
 }}}
 
-
+== Топ 5 решавачи на квизови рангирани според бројот на поени во последните 3 месеци
+
+
+{{{
+select u.username, res.points, q.quizname 
+from result_table res
+join attempt a on res.attemptid=a.attemptid
+join quiztaker qt on a.userid=qt.userid
+join user_table u on qt.userid=u.userid
+join quiz q on a.quizId=q.quizId
+where a.attemptdate between now() - interval '3 months' and now()
+order by res.points desc
+limit 5;
+}}}