Changes between Version 18 and Version 19 of WikiStart/AdvancedReports

Timestamp:

02/05/24 16:45:06 (4 months ago)

Author:

133039

Comment:

--

WikiStart/AdvancedReports

@@ -458 +458 @@
 
 }}}
-
+== **[[span(style=color: #BF1B1B, 10:)]]**
+
+{{{
+WITH student_ratings AS (
+  SELECT 
+    s.student_id,
+    AVG(fb.fb_rating) AS student_rating
+  FROM 
+    student s 
+  JOIN 
+    gives_feedback gf ON gf.student_id = s.student_id 
+  JOIN 
+    feedback fb ON gf.fb_id = fb.fb_id 
+      AND EXTRACT(YEAR FROM fb.fb_date) = EXTRACT(YEAR FROM CURRENT_DATE)
+  GROUP BY 
+    s.student_id
+)
+
+SELECT 
+  AVG(student_rating) AS average_student_rating
+FROM 
+  student_ratings;
+
+}}}