Changes between Version 8 and Version 9 of WikiStart/UseCaseModel/ImportantUseCase6

Timestamp:

02/20/24 20:09:49 (11 months ago)

Author:

121232

Comment:

--

WikiStart/UseCaseModel/ImportantUseCase6

@@ -36 +36 @@
 {{{
 --Листање на сите предмети кои студентот ги има запишано
-DECLARE correct_student_id INT;
-SET correct_student_id = 11111;
 
 SELECT
@@ -47 +45 @@
     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 
@@ -68 +64 @@
 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
 
 }}}