Create a VIEW called customers$\_$private$\_$info that contains three columns:

$$ customer$\_$id

$$ email$\_$address

$$ Passwords

Create a trigger called customers$\_$passwords$\_$length$\_$check that verifies the length of

the passwords hash is exactly $40$ characters before an update occurs. Be sure to

explain in the error that the passwords hash length must be $40.$

Provide an UPDATE statement that attempts to update a row in the

customers$\_$private$\_$info VIEW to a passwords of non $40$ length to trigger the error

message.