r carton Problem 2 pts) This is a part of Product table in Northwind database Messages Product Product Name Sccl Category Perth he 1 1 O 1 20 bags 2005 Chang 24-12 2007 Arweed Sup 12-550 13 Oulton’s Can Seasoning 2 – 50.00 52 Of Arton’s unbe Me 36 56700 Grandma’s Boyeremy Spread 12-16 740120 3 Uncle Bobgar De Pars 3 12.1 14 15 Northwonde arbe t e 12-12 d) Write a SQL query to show the product having the Second Highest UnitPrice e) Write a SQL query to show categoryID(s) along with their total UnitsInStock 1) Define a stored procedure having @SupplierID as the input parameter. The procedure should list all products provided by the input supplier. Problem 2 (6pts) This is a part of Product table in Northwind database Pet Production Supplier CategoryID Unt er Red s cort Ourg Aniseed Syrup Ord Anton’s Can Seasoning Ord Anton’s Gumbo Max Grandma’s Boyerbeny Spread Unde Bobs Organic Dried Peas de Obey Sauce QuarttyPernt 10 boxes x 20 bago 24 – 12 oz bottles 12-550 bottles 48-6 orja 36 boxes 12- 3 oz jars 12-1 bpko. 12-12 orian Unit Price Unshack $2.00 59 62.00 17 4400 13 680053 66.700 7400 1200 1400 150 10400 6 3 3 d) Write a SQL query to show the product having the Second Highest Unit Price c) Write a SQL query to show categoryID(s) along with their total UnitsInStock f) Define a stored procedure having @SupplierID as the input parameter. The procedure should list all products provided by the input supplier. Show transcribed image text r carton Problem 2 pts) This is a part of Product table in Northwind database Messages Product Product Name Sccl Category Perth he 1 1 O 1 20 bags 2005 Chang 24-12 2007 Arweed Sup 12-550 13 Oulton’s Can Seasoning 2 – 50.00 52 Of Arton’s unbe Me 36 56700 Grandma’s Boyeremy Spread 12-16 740120 3 Uncle Bobgar De Pars 3 12.1 14 15 Northwonde arbe t e 12-12 d) Write a SQL query to show the product having the Second Highest UnitPrice e) Write a SQL query to show categoryID(s) along with their total UnitsInStock 1) Define a stored procedure having @SupplierID as the input parameter. The procedure should list all products provided by the input supplier.
Problem 2 (6pts) This is a part of Product table in Northwind database Pet Production Supplier CategoryID Unt er Red s cort Ourg Aniseed Syrup Ord Anton’s Can Seasoning Ord Anton’s Gumbo Max Grandma’s Boyerbeny Spread Unde Bobs Organic Dried Peas de Obey Sauce QuarttyPernt 10 boxes x 20 bago 24 – 12 oz bottles 12-550 bottles 48-6 orja 36 boxes 12- 3 oz jars 12-1 bpko. 12-12 orian Unit Price Unshack $2.00 59 62.00 17 4400 13 680053 66.700 7400 1200 1400 150 10400 6 3 3 d) Write a SQL query to show the product having the Second Highest Unit Price c) Write a SQL query to show categoryID(s) along with their total UnitsInStock f) Define a stored procedure having @SupplierID as the input parameter. The procedure should list all products provided by the input supplier.
Expert Answer
Answer to r carton Problem 2 pts) This is a part of Product table in Northwind database Messages Product Product Name Sccl Categor…