Trigger Questions:

Create a trigger to update your table on any insert into the Animal table. The following

statements will be part of your trigger.

UPDATE AnimalNumbers SET TotalCount $=($select count$(*)$ from Animal where

Category$=$NEW.Category$)$ where Category$=$NEW.Category;

Now insert a cat into the Animal table by typing the following,

INSERT INTO Animal VALUES $(100,$ 'DODO','Cat', 'Oriental Shorthair',$\text{'}2021-01-02\text{'},$'Male', NULL,

'Brown',$150)$;