CIS376 Lab Report Week 2: Kala Willard Lab 8: Combining Results

Document Content and Description Below

CIS376 Lab Report Week 2: Kala Willard Lab 8: Combining Results Part 1 Using the WideWorldImporters database, select all rows from the table Colors in the schema Warehouse where the ColorID is bet... ween 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 Warehourse 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. 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 screenshot 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. Part 1 Using the WideWorldImporters database and the Sales schema, select CustomerNum, CreditLimit, PhoneNumber from the table Customers and the corresponding CustomerCategoyName, ValidFrom, and ValidTo from the CustomerCategories table. Review the columns to determine how to join the tables. Take a screen shot of the SQL windows and results and paste it here. Part 2 Using the AdventureWorks database and the Production schema, select the Name from the Product table, the Name from the ProductSubcategory table, and the Name and ModifiedDate from the ProductModel table. Use appropriate aliases to distinguish the Name columns from each table. Review the columns in each table to determine how to join the tables. Take a screenshot of the SQL windows and results and paste it here. [Show More]

Last updated: 1 year ago

Preview 1 out of 4 pages