Sql Programing

Part 1 Using WideWorldImporters and the Warehouse schema add the following values to the Colors table for the columns ColorName and LastEditedBy: Dark Gray, 1; Scarlet, 1; Light Gray, 1; Almond, 1; Nyanza, 1. Take a screen shot of the SQL windows and results and paste it here.

Part 2 Write a query to select all rows from the table Colors that were added in Part 1. Take a screen shot of the SQL windows and results and paste it here.

Part 3 Write a query to select all rows from the temporal table for Colors. Take a screen shot of the SQL windows and results and paste it here.

Part 4 Change the values of LastEditedBy for the rows added in Part 1 to a 9. Take a screen shot of the SQL windows and results and paste it here.

Part 5 Write a query to select all rows from the temporal table for Colors. Take a screen shot of the SQL windows and results and paste it here.

Part 1 Using the WideWorldImporters database and the Warehouse schema write a query that returns the result set transformed to XML data. The query will return StockItemID, StockItemName, Brand, Size, TaxRate, UnitPrice, ValidFrom and ValidTo from the table StockItems. The XML file will have the following structure: root name will be InventoryInfo, the path name will be Product. StockItemId will be an attribute of the path name. StockItemName and UnitPrice will be elements of the path name. Brand and Size will be attributes of an element named Descriptioin in the path name. TaxRate will be an attribute of an element named TaxInfo in the path name. ValidFrom and ValidTo will be child elements of an element named ValidDates in the path name. Take a screen shot of the SQL windows and results and paste it here.

Part 2 Double click on the resulting XML column from the above query to fully display the XML structure. Take a screen shot of the SQL windows and results and paste it here.

Part 3 Using the WideWorldImporters database and the Warehouse schema write a query that returns the result set transformed to JSON data. The query will return StockItemID, StockItemName, Brand, Size, TaxRate, UnitPrice, ValidFrom and ValidTo from the table StockItems. Take a screen shot of the SQL windows and results and paste it here.

Part 4 Using the WideWorldImporters database and the Warehouse schema write a query that returns the StockItemName, Brand, Size, and CountryOfManufacture from the JSON column CustomFields from the table StockItems. Only return rows where the CountryOfManufacture is not USA..Take a screen shot of the SQL windows and results and paste it here.