SQL homework help

I have an exercise in PL/SQL in Oracle (attached) due that I need help on, Im overloaded with my other classes and need to see if I could get help with this assignment... Also the proper table has been attached as well ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site). ## Platform ORACLE - PL/SQL TEXT FILE