Changes between Version 8 and Version 9 of AdvancedReports

Timestamp:

01/26/23 22:12:44 (20 months ago)

Author:

201060

Comment:

--

AdvancedReports

@@ -123 +123 @@
 left join question_is_part_of_quiz qipoq
 on q.questionid=qipoq.questionid
-left join attempt a on qipoq.quizid=a.quizid
+left join attempt a 
+on qipoq.quizid=a.quizid
 where s.choiceid=c.choiceid and c.iscorrect
 and a.attemptdate between now() - interval '1 year' and now()
@@ -167 +168 @@
 }}}
 
-== Квизови рангирани според бројот на точно одговорени прашања
+== Рангирани квизови според бројот на точно одговорени прашања во последниот месец
 
 
@@ -186 +187 @@
 left join selectedchoice s 
 on s.choiceid = c.choiceid
+left join attempt a
+on q.quizid=a.quizid
 where s.choiceid=c.choiceid and c.iscorrect
+and a.attemptdate between now() - interval '1 month' and now()
 group by 1
 order by counter