- SQL report for cohort enrolled in course (or competency of same name) with their actual_score, required_score and the gap.
- I made a table called mdl_competency_gap with id, cohort_id, course_name, and required_score.
- I tried SQL ad hoc report in configurable reports plugins.