Changes between Version 3 and Version 4 of AdvancedReports

Timestamp:

01/11/23 00:29:54 (21 months ago)

Author:

201100

Comment:

--

AdvancedReports

@@ -103 +103 @@
 
 
+== Прашања рангирани според бројот на точни одговори
+
+
+{{{
+select   q.questiontext, 
+         count(s.choiceid) as counter  
+
+from question q
+
+join selectionquestion sq 
+on q.questionid = sq.questionid 
+left join choice c 
+on c.questionid = q.questionid
+left join selectedchoice s 
+on s.choiceid = c.choiceid
+where s.choiceid=c.choiceid and c.iscorrect
+group by 1
+order by counter
+}}}
+
+