sql server

please help me>>>

Create a stored procedure called uspRetrieveOrders that returns all the orders for a last name. It should return first name, last name, item price, discount amount, quantity, the line item extended amount ((ItemPrice-DiscountAmount)*Quantity), the tax amount, and the card type. It should accept LastName as a parameter. Include logic to test if the customer exists in the database. If not, generate an error message. Show the code you used to test the proc.

"Get 15% discount on your first 3 orders with us"
Use the following coupon
"FIRST15"

Order Now