Question: I need the SQL code for each part with a screen shot Writing Queries against XML and JSON Data. This is the example Part 1

I need the SQL code for each part with a screen shot

Writing Queries against XML and JSON Data. This is the example

I need the SQL code for each part with a screen shot

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.

-Part4 Use WideWorldImporters; Go Select * From Warehouse. Colors; # Purchasing SupplierTransactions # Sales.Buying Groups (System-Versioned) Sales. CustomerCategories (System-Versioned # Sales Customers (System-Versioned) # Sales. Customer Transactions Sales.InvoiceLines # E Sales.Invoices # Sales. OrderLines # Sales. OrderLines_bak # Sales. Orders # Sales.SpecialDeals # Warehouse.Cold Room Temperatures (System # Warehouse.Colors (System-Versioned) Warehouse.PackageTypes (System-Versioned # Warehouse StockGroups (System-Versioned) Warehouse StockItem Holdings # Warehouse StockItems (System-Versioned) # Warehouse StockItemStockGroups # B Warehouse StockItem Transactions Warehouse.VehicleTemperatures Views External Resources Synonyms Programmability Query Store Service Broker Insert Warehouse. Colors (ColorName, LastEditedBy) Values('Dark Gray',9) ('Scarlet',9). ('Light Gray',9) 110 % al Messages (5 rows affected) 110 % Query executed successfully. SQL-NUG (13.0 SP1) SQL-NUG\Administrator ... WideWorldImporters 00:00:00 Orow. -Part4 Use WideWorldImporters; Go Select * From Warehouse. Colors; # Purchasing SupplierTransactions # Sales.Buying Groups (System-Versioned) Sales. CustomerCategories (System-Versioned # Sales Customers (System-Versioned) # Sales. Customer Transactions Sales.InvoiceLines # E Sales.Invoices # Sales. OrderLines # Sales. OrderLines_bak # Sales. Orders # Sales.SpecialDeals # Warehouse.Cold Room Temperatures (System # Warehouse.Colors (System-Versioned) Warehouse.PackageTypes (System-Versioned # Warehouse StockGroups (System-Versioned) Warehouse StockItem Holdings # Warehouse StockItems (System-Versioned) # Warehouse StockItemStockGroups # B Warehouse StockItem Transactions Warehouse.VehicleTemperatures Views External Resources Synonyms Programmability Query Store Service Broker Insert Warehouse. Colors (ColorName, LastEditedBy) Values('Dark Gray',9) ('Scarlet',9). ('Light Gray',9) 110 % al Messages (5 rows affected) 110 % Query executed successfully. SQL-NUG (13.0 SP1) SQL-NUG\Administrator ... WideWorldImporters 00:00:00 Orow

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

This is a continuation of my previous questions: Part 2 Add additional tables to the volunteer database to track hours worked per week by the volunteers and amounts of funds raised. Remember to...

Please just answer part B. I have part A done a. Suppose you have a Shape hierarchy as follows: Shape Now you want to add a Circle class, but you hear that someone else has already created one, named...

Using the relations that you defined and normalized as part of the unit 4 assignment posted above , create the SQL DML statements necessary to implement your database schema as an OpenOffice...

Using the relations that you defined and normalized as part of the unit 4 assignment, create the SQL DML statements necessary to implement your database schema as an OpenOffice database. You may also...

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,...

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,...

Which one of the following would be considered a user of management accounting information? A Stockholders B Controller C Creditors D Suppliers 2. Which of the following would NOT be a characteristic...

In any meeting of 4 people we choose randomly 3 individuals. Use Graph Theory to show that the probability that the 3 picked individuals all know each other is equal to the probability that no one...

Fiter Corporation has a project avallable with the following cash flows: \ table [ [ Year , Cash Flow ] , [ 0 , - $ 1 4 , 4 0 0 MC algo 9 - 2 2 Calculating Profitability Index A project has the...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

KEY QUESTION Columns 1 through 4 in the table below show the marginal utility, measured in utils, that Ricardo would get by purchasing various amounts of products A, B, C, and D. Column 5 shows the...

KEY QUESTION What is the formula for measuring the price elasticity of supply? Suppose the price of apples goes up from $20 to $22 a box. In direct response, Goldsboro Farms supplies 1200 boxes of...

How is the $10 best allocated between A and B? How much utility will the marginal dollar yield?