SQL homework, Script needs to be modified as well

I need a 3 easy SQLqueries Create a simple stored procedure, Create a trigger for your database, Create a user defined function OR a view. But database script needs some changes as well to do this questions. Note: I use oracle live sql

  1. Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount