Changes between Version 7 and Version 8 of AdvancedReports

Timestamp:

01/26/23 22:05:52 (17 months ago)

Author:

201060

Comment:

--

AdvancedReports

@@ -64 +64 @@
 
 
-== Најиграни квизови
+== Најиграни квизови во последните 6 месеци
 
 
@@ -72 +72 @@
 from quiz q
 join attempt a on q.quizid=a.quizid
-where a.attemptdate between now() - interval '2 years' and now()
+where a.attemptdate between now() - interval '6 months' and now()
 group by 1
 order by count(a.attemptid)
@@ -106 +106 @@
 
 
-== Прашања рангирани според бројот на точни одговори
+== Прашања рангирани според бројот на точни одговори во последната година
 
 
@@ -121 +121 @@
 left join selectedchoice s 
 on s.choiceid = c.choiceid
+left join question_is_part_of_quiz qipoq
+on q.questionid=qipoq.questionid
+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()
 group by 1
 order by counter