== 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.


{{{#!sql
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;

}}}