Answer the question by writing queries in SQL.

Create a stored procedure ListCustomer Sales with an input parameter y, which lists the total sale ($) contributed by each customer in year y. (Only show the customers that have made orders in Year y) 5% CustomerID | CustomerName Sales Contribution ($) DoesBusinessin_T Customer Territory 88 Allow Nuts Customer Customer CustomerName CustomerShipAddress_T Column Name Dars Type ShipAddress PE Customer Territory ShipAddress nvarchar(301 Ship nvarchar 201 nvarchari) Gomaddess Territory T Territory TerritoryName Customer City CustomerStare Customers Code Shipp Ship Directions nvarchar(101 nvarchar255 Supplies 1 8 Vendor Material Supply UnitPrice Raw Material T 9 Martial Materialen Thickness With Size Material Material Standard Price Unico Measure Maratatypes Vendor T Vendor Vendarlame Vendorddress Vendary Vendor Seat Payment_T 9 Payment Order Paymente Pay-TypeID Pay Amount Commen Vendor pode Vendor Phone Vendorfa Number Vendor Contact Vendor Number 88 Order_T 9 Order Orderate Customer Fulfillmente Sales Person ShipAdD Uses T 9 Product Material Payment Types 9 PaymentTypeID Typ Description Employee_T 9 Employee Employee Name Employee Address Employee Salesperson T 8 Selespeto Salesperson Name Salespersone echong Salespersonax Sales Terror Salesperson Address Salesperson Salespersonale Selesperson Employee State Employeep EmployeeDetetired Employee thate Employee Superior Shipped Orderlin Shipped Quantity Shipped Date Worksint Employee 9 Wort Center EmployeeSkills_T Employee sp Qualitate Product 9 Producto Product Description Produch Productandard Price Productor and Productline Photo Order Line T Orderline Order ProductID WorkCenter_T 9 Wort Center Worcemerlocation Skill_T SD Sid Description ProductLine 1 Productline Productliname Producedin_T 9 Product WorkCemer Create a stored procedure ListCustomer Sales with an input parameter y, which lists the total sale ($) contributed by each customer in year y. (Only show the customers that have made orders in Year y) 5% CustomerID | CustomerName Sales Contribution ($) DoesBusinessin_T Customer Territory 88 Allow Nuts Customer Customer CustomerName CustomerShipAddress_T Column Name Dars Type ShipAddress PE Customer Territory ShipAddress nvarchar(301 Ship nvarchar 201 nvarchari) Gomaddess Territory T Territory TerritoryName Customer City CustomerStare Customers Code Shipp Ship Directions nvarchar(101 nvarchar255 Supplies 1 8 Vendor Material Supply UnitPrice Raw Material T 9 Martial Materialen Thickness With Size Material Material Standard Price Unico Measure Maratatypes Vendor T Vendor Vendarlame Vendorddress Vendary Vendor Seat Payment_T 9 Payment Order Paymente Pay-TypeID Pay Amount Commen Vendor pode Vendor Phone Vendorfa Number Vendor Contact Vendor Number 88 Order_T 9 Order Orderate Customer Fulfillmente Sales Person ShipAdD Uses T 9 Product Material Payment Types 9 PaymentTypeID Typ Description Employee_T 9 Employee Employee Name Employee Address Employee Salesperson T 8 Selespeto Salesperson Name Salespersone echong Salespersonax Sales Terror Salesperson Address Salesperson Salespersonale Selesperson Employee State Employeep EmployeeDetetired Employee thate Employee Superior Shipped Orderlin Shipped Quantity Shipped Date Worksint Employee 9 Wort Center EmployeeSkills_T Employee sp Qualitate Product 9 Producto Product Description Produch Productandard Price Productor and Productline Photo Order Line T Orderline Order ProductID WorkCenter_T 9 Wort Center Worcemerlocation Skill_T SD Sid Description ProductLine 1 Productline Productliname Producedin_T 9 Product WorkCemer