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