Changes between Version 4 and Version 5 of WikiStart/AdvancedReports

Timestamp:

01/29/24 13:24:38 (8 months ago)

Author:

121232

Comment:

--

WikiStart/AdvancedReports

@@ -195 +195 @@
 == **[[span(style=color: #BF1B1B, 6. Листање(приказ) на сите евенти и task-ови за зададен предмет:)]]**
 
-== **[[span(style=color: #BF1B1B, 7. Листање(приказ) на сите на сите книги и автори по одреден предмет:)]]**
+== **[[span(style=color: #BF1B1B, 7. Листање(приказ) на сите на сите книги и автори по одреден предмет (пример:Бази на податоци):)]]**
+
+{{{
+DECLARE correct_student_id INT;
+SET correct_student_id = 11111;
+
+WITH SubjectBooks AS (
+    SELECT 
+        rb.book_id,
+        rb.book_title,
+        ba.author_id,
+        a.author_name
+    FROM 
+        recommended_book AS rb
+    JOIN 
+        book_author AS ba ON rb.book_id = ba.book_id
+    WHERE 
+        rb.subject_name = 'Bazi na podatoci'
+        AND rb.student_id = correct_student_id
+)
+
+SELECT 
+    sb.book_id,
+    sb.book_title,
+    sb.author_id,
+    sb.author_name
+FROM 
+    SubjectBooks AS sb;
+
+}}}
+
 
 == **[[span(style=color: #BF1B1B, 8. Приказна на сите feedbacks (описи и наслови на feedback) со оценка помала од 3:)]]**
 
 
-
+{{{
+DECLARE correct_student_id INT;
+SET correct_student_id = 11111;
+
+SELECT 
+    fb.fb_id,
+    fb.fb_date,
+    fb.fb_title,
+    fb.fb_description,
+    fb.fb_rating
+FROM 
+    feedback AS fb
+WHERE 
+    fb.fb_rating < 3
+    AND EXISTS (
+        SELECT 1
+        FROM 
+            gives_feedback AS gf
+        WHERE 
+            gf.fb_id = fb.fb_id
+            AND gf.student_id = correct_student_id
+    );
+}}}
+
+
+
+