Lab Assignment Directions

IMPORTANT:  Task #3 is the only one that requires subqueries!   The rest of the assignment is a review of information we have covered throughout the semester!

PLEASE READ:  After you create the testcorp database, when you query the Order table, you will need to put it in brackets to use the table because SSMS thinks it is a keyword.   Use [Order] when you refer to the table and everything should work fine.

Example:  SELECT * FROM [Order]