Computer Science Homework Help

I need help with a SQL Server assignment.  I have attached the assignment below.

The requirements:

– Explain all of the SQL statements/clauses/operators in the assignment

– Create
tables with about 10 instances (rows) in SQL Server to explain the SQL code and demonstrate the query results. 

– Use screencasting tool, Screencast-O-Matic ( http://www.screencast-o-matic.com ) to create a screencast or a series of screencasts for the assignment.

– Screencast video should be not be longer than 5 minutes. 

– Insert Powerpoint slides in screencast if needed.

** Please upload the completed screencast video, any Powerpoint slides (if any are used), the tables that you created in SQL Server, as well as a draft of the screencast script.  I need everything that is used in the screencast video, so that I am able to recreate my own video to submit.