Changes between Version 2 and Version 3 of AdvancedReports

Timestamp:

01/11/23 00:01:25 (23 months ago)

Author:

201100

Comment:

--

AdvancedReports

@@ -36 +36 @@
 }}}
 
+
 == Вкупен број на организирани турнири, играчи и медали
 
@@ -63 +64 @@
 
 
+== Најиграни квизови
 
 
+{{{
+select   q.quizname, 
+         count(a.attemptid)
+from quiz q
+join attempt a on q.quizid=a.quizid
+where a.attemptdate between now() - interval '2 years' and now()
+group by 1
+order by count(a.attemptid)
+
+}}}
+
+
+== Просечни поени по квиз
+
+
+{{{
+select qt.userid, q.quizname, avg(rt.points) from quiztaker qt
+left join attempt a on qt.userid= a.userid
+left join quiz q on q.quizid=a.quizid
+left join result_table rt  on a.attemptid=rt.attemptid
+group by 1, 2;
+}}}
+
+
+== Вкупен број решени квизови во последните 3 месеци
+
+
+{{{
+select count(qu.quizid) as broj_resheni_kvizovi
+from quiz qu 
+join attempt at on qu.quizid = at.quizid 
+join quizTaker qt on at.userid  = qt.userid
+and at.attemptdate between now() - interval '3 months' and now()
+}}}
+
+