be sure to constrain the select to the course_id that is being delete