CREATE TRIGGER taaaaaaaaaaaa_rental_rate

BEFORE

INSERT OR

UPDATE OF rental_rate, film_id, special_features

ON film

트리거를 만드는중 created 라고는 뜨는대 with compolation Error 라고 뜨는대 어디가 문제인지 알수있을가요

DECLARE special_features

BEGIN

CASE

IF (special_features = ‘Trailers’)

THEN rental_rate := rental_rate + 0.10;

IF (special_features = ‘Commentaries’)

THEN rental_rate := rental_rate + 0.50;

IF (special_features = ‘Deleted Scenes’)

THEN rental_rate := rental_rate + 0.20;

IF (special_features = ‘Behind the Scenes’)

THEN rental_rate := rental_rate + 0.20;

END CASE;

END;

/

질문은 새로운 film 이 추가된뒤로 rental_rate 를 올려야하는건대. 왜 compilation error 가 뜰까요