(24pt) Chapter 7, p.183, Exercise 1-7 and 10. Please put your statements in an SQL script file lab7.sql. and upload it to CSNS at the end of the lab. File uploading will be disabled automatically after 11:30am 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.