I need help with a SQL Server assignment.&nbsp I have attached

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- Createtables 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.