Question: Prompt: The Finance Manager asks you to develop a query that includes these attributes in this order: the country of the supplier, the product units

Prompt: The Finance Manager asks you to develop a

Prompt: The Finance Manager asks you to develop a query that includes these attributes in this order: the country of the supplier, the product units in stock, units on order, and a column that calculates the total dollar value of the quantity that is in stock for each product and named as In-Stock Value. Restrict the query output as follows and in this order: include only those products supplied by suppliers who are in Sweden, Finland, or Norway, and products with units in stock levels of at least 1 but no more than 20. Last, sort the output by the supplier country name and then the column "In-Stock Value. SQL Statement (case sensitive, must reflect what was used in SQL Browser to execute the prompt): SELECT Supplier.Country, Product.UnitsInStock, Product.UnitsOnOrder, Product.UnitPrice "In-Stock Value" FROM Supplier JOIN Product ON Supplier.SupplierID=Product.SupplierID WHERE Supplier.Country="Sweden" 11 Supplier.Country="Finland" Supplier.Country=" Product.UnitsInStock BY Supplier.Country, "In-Stock Value

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 General Management Questions!