CREATE TRIGGER RegisterCheck
        BEFORE INSERT ON Registrations
        REFERENCING NEW AS insertRow
        FOR EACH ROW
        WHEN (1=2)
        BEGIN
                INSERT INTO Waits(student,course,waitNo)
                VALUES(:insertRow.student, insertRow.course,
                        (SELECT Count(*) FROM Waits WHERE course=:insertRow.course)
                );
        END;
/