---

INNER JOIN program p USING(program_id)
INNER JOIN program_enrollee pe USING(program_id)
INNER JOIN enrollee e USING(enrollee_id)
INNER JOIN enrollee_subject es ON es.subject_id = ps.subject_id
AND es.enrollee_id = pe.enrollee_id