FiLMS v2 Notes

SELECT u.name_last, u.name_first, date_birth, c.NAME AS 'Course Name', cu.time_completed, cu.final_score

FROM course_users AS cu

LEFT JOIN courses AS c

ON c.id = cu.course_id

LEFT JOIN users AS u

ON u.id = cu.user_id

WHERE time_completed IS NOT NULL

AND security_level_id <> 'AS'

AND cu.time_completed > '2019-01-01'