Changes between Version 9 and Version 10 of WikiStart/UseCaseModel/ImportantUseCase5

Timestamp:

02/20/24 20:08:20 (7 months ago)

Author:

121232

Comment:

--

WikiStart/UseCaseModel/ImportantUseCase5

@@ -26 +26 @@
 
 {{{
-DECLARE correct_student_id INT;
-SET correct_student_id = 11111;
 
 SELECT 
@@ -47 +45 @@
         AND sat.starting_year = sbe.starting_year
         AND sat.finishing_year = sbe.finishing_year
-        AND sat.student_id = sbe.student_id -- Fixed alias from se to sbe
+        AND sat.student_id = sbe.student_id 
 WHERE 
     nre.event_date >= CURRENT_DATE
     AND ce.event_type = 'Exam'
-    AND sbe.student_id = correct_student_id
+    AND sbe.student_id = 11111
 ORDER BY 
     nre.event_date,
@@ -73 +71 @@
 {{{
 --Листање на сите предмети кои студентот ги има запишано
-DECLARE correct_student_id INT;
-SET correct_student_id = 11111;
 
 SELECT
@@ -84 +80 @@
     subject_at_term
 WHERE 
-    student_id = correct_student_id
+    student_id = 11111
 ORDER BY 
     finishing_year DESC; 
+
 --Листање на сите места внесени од студентот
-DECLARE correct_student_id INT;
-SET correct_student_id = 11111;
 
 SELECT 
@@ -104 +99 @@
 ON sje.calendar_event_id = ce.calendar_event_id
 WHERE
-        se.student_id = correct_student_id
-        OR sje.student_id = correct_student_id
+        se.student_id = 11111
+        OR sje.student_id = 11111
 
 }}}