Viewing Available Courses

Actors: Guest User, Registered User

1. Open Course Catalog: a guest user or a registered user opens the course catalog page.

2. The system displays all active courses.

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';