Viewing Enrolled Students per Course (Instructor)

Actors: Instructor (INSTRUCTOR)

1. The instructor opens the Overview for a specific course.

2. Retrieving Enrolled Students and Their Progress.

SELECT 
    ue.first_name, ue.last_name,
    e.enroll_date, e.progress_percentage, e.completion_status
FROM enrollment e
JOIN users u ON u.id = e.user_id
JOIN user_entity ue ON ue.id = u.id
WHERE e.course_id = :courseId;