Movie theatre database | Computer Science homework help

 I use SQLDeveloper but it does not matter 

The assignment is a movie theatre database system. I have completed the tables but need help with 3 features relating to purchasing tickets. In the zip file, I have the code for the tables, as well as a description of the features that need to be done.

"Get 15% discount on your first 3 orders with us"
Use the following coupon
"FIRST15"

Order Now