While you are reading this chapter you will complete the SQL queries presented in each section listed below. In other words, completing the SQL query means entering the query in MS SQL Server Management Studio, and then Clicking on EXECUTE. Creating the query examples from the sections below makes more sense than just reading the examples. The USE command (in this case USE CH07_SALECO) is needed only once when the original script for the CH07_SALECO database is run (this creates the tables and populates each of them with data). The original script is the one attached to this assignment (CH07_SALECO_SQL.sql ). The name is not case-sensitive. There are some examples that will not execute without errors. The first error you

Ch07_SaleCo_SQL.sql (11.528 KB

Assignment 7-1 rev.pdf