1. Use Subquery to list the animalid, list price and breed of dogs that have a list price greater than the average list of dogs taht are of breed Cocker Spaniel or Norfolk Terrier. Sort in Descending order.

2. Write a delete statement that deletes all of the unpaid invoices in the invoiceCopy table that are from vendors located in either MI or CA. (You may use subquery or join).

3. Create a view named Top5EmpsByBirdValue that returns employee id, lastname and total(where total is the summation of cat listprice value.) Show only top 5 in descending order

Please solve all of them correctly