Week_2_Lab_Reports.docx.pdf

Document Content and Description Below

Part 1 Using the WideWorldImporters database, select all rows from the table Colors in the schema Warehouse where the ColorID is between 1 and 15 and combine with all rows where the ColorID is betwe... en 12 and 20. Eliminate duplicate rows. Take a screen shot of the SQL windows and paste it here Part 2 This study source was downloaded by 100000822447745 from CourseHero.com on 07-17-2022 12:32:55 GMT -05:00 https://www.coursehero.com/file/70833055/Week-2-Lab-Reportsdocx/Using the WideWorldImporters database, select all rows from the table Colors in the schema 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 screen shot 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. [Show More]

Last updated: 1 year ago

Preview 1 out of 6 pages