FOR EACH ROW
        BEGIN
                IF( :insertRow.course IN (SELECT * FROM FullCourses) )
                THEN
                INSERT INTO Waits(student,course,waitNo)
                VALUES(:insertRow.student, :insertRow.course,
                        (SELECT Count(*) FROM Waits WHERE course=:insertRow.course)
                );
                ENDIF
        END;