DO NOT USE AI OR GPT SOLVE IT PROPERLY

READ THE QUESTION

SOLVE Q$1$ AND Q$2$

YOU HAVE TO FILL IN THE BLANK "WRITE DOWN WHAT'S HIDDEN HERE"

Mini$-$assignment $($see $7\mathrm{.}5\mathrm{.}2)$

MovieExec$($name$,$ address, cert#$,$ netWorth$)$

We want to keep the average networth above $50000.$

This trigger is for updates.

Write a similar trigger for insertions.

CREATE TRIGGER AvgNetWorthTrigger

AFTER UPDATE OF netWorth ON MovieExec

REFERENCING

OLD TABLE AS OldStuff,

NEW TABLE AS NewStuff

FOR EACH STATEMENT

CREATE TRIGGER AvgNetWorthTrigger$2$

AFTER INSERT ON MovieExec

Q$1$: WRITE DOWN WHAT'S HIDDEN HERE

FOR EACH STATEMENT

WHEN $(500000>($SELECT AVG$($netWorth$)$ FROM MovieExec$))$

Q$2$: WRITE DOWN WHAT'S HIDDEN HERE

WHEN $(500000>($SELECT AVG$($netWorth$)$ FROM MovieExec$))$

BEGIN

DELETE FROM MovieExec

WHERE $($name$,$ address, cert#$,$ netWorth$)$ IN NewStuff;

INSERT INTO MovieExec $($SELECT $*$ FROM OldStuff$)$;

END;