(24pt) Chapter 7, p.183, Exercise 1-7 and 10. Please put your statements in an SQL script file lab8.sql. and upload it to CSNS at the end of the lab. File uploading will be disabled automatically after 4:00pm so please turn in your work on time.

Note that:

• You should use only one statement for each exercise except Ex.5, which takes two INSERT statements.
• For Ex.2, do not use Bob or Lisa's SalesID directly, i.e., use subqueries in the UPDATE statement to obtain Bob and Lisa's SalesID.
• For Ex.6 and Ex.7, ignore the part that says "then rollback the delete" since we have not covered transactions yet.