Changes between Version 6 and Version 7 of AdvancedReports

Timestamp:

01/11/23 01:38:43 (21 months ago)

Author:

201100

Comment:

--

AdvancedReports

@@ -83 +83 @@
 
 {{{
-select qt.userid, q.quizname, avg(rt.points) from quiztaker qt
+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
@@ -128 +131 @@
 
 {{{
-select u.username, count(miatq.medalid) as medal_count from quiztaker qt
-left join medal_is_awarded_to_quiztaker miatq on qt.userid = miatq.userid 
-left join user_table u on qt.userid = u.userid 
+select   u.username, 
+         count(miatq.medalid) as medal_count 
+
+from quiztaker qt
+
+left join medal_is_awarded_to_quiztaker miatq 
+on qt.userid = miatq.userid 
+left join user_table u 
+on qt.userid = u.userid 
 group by 1
 order by medal_count
@@ -154 +163 @@
 }}}
 
+== Квизови рангирани според бројот на точно одговорени прашања
 
 
+{{{
+select   q.quizname, 
+         count(qipoq.questionid)  as counter 
+
+from quiz q
+
+left join question_is_part_of_quiz qipoq 
+on qipoq.quizid = q.quizid 
+join question que 
+on que.questionid = qipoq.questionid 
+join selectionquestion sq 
+on que.questionid = sq.questionid 
+left join choice c 
+on c.questionid = que.questionid
+left join selectedchoice s 
+on s.choiceid = c.choiceid
+where s.choiceid=c.choiceid and c.iscorrect
+group by 1
+order by counter
+}}}
+
+