CREATE OR REPLACE VIEW CourseEnrollmentDelete AS
    SELECT CE.course, CE.student, since
    FROM CourseEnrollment CE LEFT JOIN WaitingFor WF
        ON CE.course = WF.course
;