Information Technology > Lab Report > Combining Results (All)

Combining Results

Document Content and Description Below

LAB 8: Combining Results INSTRUCTIONS: • Prior to starting this lab, be sure you have done the following: a. Read Skill 1.1 in the textbook b. Watched Video 8 in CBT Nuggets c. Familiarize your ... self with the SQL commands in the textbook and videos • There are multiple parts to this lab, be sure to clear all the SQL before completing the next part. • Sign each lab part. The first line in the SQL Window must be a comment with your Name, Student ID, and Lab number. The following is an example: • For each part of the lab, you will be required to take a screenshot of the SQL window and result pane. If there are more results than fill the screen only captures the initial results. The following is an example of what is expected: Using the WideWorldImporters database, select all rows from the table Colors in the schema A warehouse where the ColorID is between 1 and 15 and combine with all rows where the ColorID is between 12 and 20. Eliminate duplicate rows. Take a screenshot of the SQL windows and paste it here. Part 2 Using the WideWorldImporters database, select all rows from the table Colors in the schema The warehouse where the ColorID is between 10 and 30 and combine with all rows where the ColorID is between 12 and 20. Include duplicate rows. Take a screenshot of the SQL windows and paste it here. Part 3 Using WideWorldImporters select ColorID from the table Colors in the Warehouse schema that does not match the ColorID from the table StockItems in the Warehouse schema . Take a screen shot of the SQL windows and paste it here. Part 4 Using WideWorldImporters select ColorID from the table Colors in the Warehouse schema that matches the ColorID from the table StockItems in the Warehouse schema . Take a screenshot of the SQL windows and paste it here. [Show More]

Last updated: 3 years ago

Preview 1 out of 4 pages

Buy Now

Instant download

We Accept: