You can download the document here:
This is a word document which contains all of the SQL needed for these requirements.
You will find my comments about a few changes in red.
First you will find all of the CREATE TABLE statements. These have to be run in the order they are in the document because of foreign key constraints.
Then I included enough insert statements to make the queries (a-e) actually return data. You can, of course, add as many inserts as you want/need. Simply use the inserts that I have provided as templates.
After that, you will find the SELECT queries (A-E).
All queries in the file have been run in Oracle and work correctly.
Let me know if you have any issues or questions. I'm here to help.
If you require assistance with databases or web development in the future, please feel free to ask for me directly by starting your questions with **For TheDoctor**. It would be my pleasure to assist you again.
Please remember to rate my answer. It is the only way that I receive credit for my time and effort. If you require more assistance, simply continue our conversation before leaving any rating.
Thank you so much for using JustAnswer. Have a great day!