Skip to content

Nombre d'élèves uniques et de sessions pour un enseignant

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
SELECT
    COUNT(DISTINCT cucsp.user_id) AS nb_eleves_uniques,
    COUNT(cucsp.user_id) AS nb_sessions_total
FROM
    classroom_course_session ccs
        JOIN classroom_user_course_session_pivot cucsp ON cucsp.course_session_id = ccs.id
WHERE
    ccs.status = 'COMPLETED'
  AND ccs.deleted_at IS NULL
  AND ccs.started_at BETWEEN ':start_date 00:00:00'
    AND ':end_date 23:59:59'
  AND ccs.user_id = (
    SELECT
        id
    FROM
        user
    WHERE
        email = ':teacher_email'
      AND deleted_at IS NULL
);

Keywords

select classroom_course_session classroom_user_course_session_pivot user teacher live classroom