Create a stored procedure. The requirements are:  The user would like to see the most valuable supplier by finding which supplier provides the highest number of individual products to the company. The results should show the company, the last name and the state of the supplier in addition to the number of individual products supplied by the supplier.

 

Employees EmpID LastName FirstName Job Title Phone Products 8 ProductID ProductCode ProductName Description CategoryID StandardCost ListPrice ReorderLevel TargetLevel Discontinued Supplier D Suppliers Supplier D Company LastName FirstName BusinessPhone City State 8 Purchase OrderDetails Order Detaill D Purchase Order D ProductID Quantity UnitCost Posted Toinventory InventoryID Category CategoryID CategoryName