Create A stored Procedure in SQL

Using the Northwind database orders table, write a single script that completes the following tasks: Create a view showing every order that was shipped to Spain. Name the destination column "DestinationSpain". Include code that checks if the view already exists. If it does, it should be dropped and re-created. Create another view that returns the name of each country and the number of orders shipped to that country. Name the number of orders column "NumOrders.” Include code that checks if the view already exists. If it does, it should be dropped and re-created. Have the script display all the rows from the first view. Have the script display all the rows from the second view. Finally, have the script display the total number of orders shipped to Spain. Name the column "TotalOrdersToSpain". Using the Query Analyzer, make sure your script has no errors when it's executed. Then save and submit the .sql file. STEP THREE - Writing a Stored Procedure Complete the following tasks using the Northwind database table Order details: [login to view URL] a stored procedure named sp_insert_orderDetails that allows you to add a discount to an order. The stored procedure should accept five input parameters: OrderID, ProductID, UnitPrice, Quantity, and DiscountValue. 2. Have the stored procedure display all the orders with a discount, including the ones added by the stored procedure. After testing the stored procedure and receiving no errors, save the .sql file.