Triggers:

First complete the following three steps prior to completing Questions $4$ and $5.$

Step $1$: Create this table:

CREATE TABLE AnimalNumbers $($

C$\_$ID char$(2)$ not null primary key,

Category VARCHAR$(100),$

TotalCount INTEGER$)$ engine $=$ InnoDB;

Step $2$: Add $6$ rows of data:

Insert into AnimalNumbers values

$(\text{'}$A$1\text{'},$ 'Dog',$0),$

$(\text{'}$B$1\text{'},$'Cat',$0),$

$(\text{'}$C$1\text{'},$'Bird',$0),$

$(\text{'}$D$1\text{'},$'Fish',$0),$

$(\text{'}$E$1\text{'},$'Reptile',$0),$

$(\text{'}$F$1\text{'},$'Spider',$0)$;

Step $3$: Update the data to reflect how many animals in each category are currently in the

Animal table.

UPDATE AnimalNumbers set TotalCount select count ${(}^{**})$ from Animal where category $=$

AnimalNumbers.Category$)$;

give the detail step of how to do this, and show the sql query.