Changes between Version 1 and Version 2 of ViewingAvailableCourses

Timestamp:

01/22/26 02:56:34 (16 hours ago)

Author:

221296

Comment:

--

ViewingAvailableCourses

@@ -3 +3 @@
 ==== Actors: **Guest User, Registered User**
 
-**1.** A guest or registered user opens the course list.
+**1.** Open Course Catalog:
+A guest user or a registered user opens the course catalog page.
 
 **2.** The system displays all active courses.
@@ -9 +10 @@
 
 {{{#!sql
-SELECT course_id, name, price, status
-FROM course
-WHERE status = 'ACTIVE';
-
+SELECT c.course_id, c.name, c.price, c.status,
+       ue.first_name || ' ' || ue.last_name AS instructor
+FROM course c
+JOIN instructors i ON c.instructor_id = i.id
+JOIN user_entity ue ON ue.id = i.id
+WHERE c.status = 'ACTIVE';
 
 }}}