Viewing Enrolled Students per Course (Instructor)

Actors: Instructor (INSTRUCTOR)

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

2. The system generates a report with enrolled users and their progress.

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