Changes between Version 5 and Version 6 of AdvancedReports

Timestamp:

01/11/23 00:49:36 (21 months ago)

Author:

201100

Comment:

--

AdvancedReports

@@ -134 +134 @@
 order by medal_count
 }}}
+
+
+== Рангирани корисници според бројот на обиди во последната година
+
+
+{{{
+select   u.username, 
+         count(a.attemptid) as attempted_quizzes 
+
+from quiztaker q 
+
+left join user_table u 
+on q.userid = u.userid 
+left join attempt a 
+on a.userid = q.userid 
+where a.attemptdate between now() - interval '1 year' and now()
+group by 1
+order by attempted_quizzes
+}}}
+
+
+