Procedures:

Create a procedure named AnimalCategorySales which takes cust$\_$id as the input and returns

category and breed of animals they purchased.

Required: apply if else condition that returns category and breed if customer's sales data exists.

If otherwise, return an error message showing "Customer has not purchased an animal".

Note, for your input variable, name it cust$\_$id something different than PetCustomerID and it

should be a data type of INT

Test it out by typing: Call AnimalCategorySales$(9)$; you should get $2$ rows back.

Try it again with Call AnimalCategorySales$(13)$; and you should get your error message from

above.

$**$Type the command "show create procedure AnimalCategorySales" and screenshot the first

three columns of the output of this command $($Procedure$,$ sql$\_$mode, Create Procedure$)$

$**$Also$,$ copy and paste your procedure code.