Query

SELECT
    users.first_name,
    users.last_name,
    paths_trackings.enrolled_at,
    paths_trackings.is_self_enrolled,
    paths.name AS path_name,
    paths_sessions.name AS path_session_name,
    paths_trackings.start_date,
    paths_trackings.completed_at,
    paths_trackings.score,
    paths_trackings.result
FROM qwnogpy_ww21770_datasharing.core.paths_trackings
INNER JOIN qwnogpy_ww21770_datasharing.core.users
    ON users.id = paths_trackings.user
LEFT JOIN qwnogpy_ww21770_datasharing.core.paths
    ON paths.id = paths_trackings.path_id
LEFT JOIN qwnogpy_ww21770_datasharing.core.paths_sessions
    ON paths_sessions.id = paths_trackings.path_session

Description

• first_name: First name of the learner
• last_name : Last name of the learner
• enrolled_at : Timestamp when the learner was enrolled to the path session
• is_self_enrolled: TRUE if the learner self-enrolled to the path session
• path_name: Name of the path of this path session
• path_session_name: Name of the path session
• start_date : Date when the learner started the path session
• completed_at : Date when the learner achieved the path session (if any)
• score : Score of the learner on the path session
• result : Result of the learner on the path session