Combining Results
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 betwee
...
Combining Results
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 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 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.
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 screen shot 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.
Part 3
Using WideWorldImporters and the Sales schema, select the CustomerName for the table Customers and the
CustomerCategoryName from the table CustomerCategories showing all categories with or without customers. Review the columns
in each table to determine how to join the tables. Take a screen shot of the SQL windows and results and paste it here
[Show More]
