Question: Write a script that creates a function within a procedure using your guitar shop database named BudgetProducts. This procedure should take accept an input called

Write a script that creates a function within a procedure using your guitar shop database named BudgetProducts. This procedure should take accept an input called budget which should be the same data type as the field we will be comparing it against. We want to pull the product_id, product_name, description, List_price, and sale_price. We want to filter our results so that only
products with a sale price less than the budget are displayed. Sale price equals list_price (list_price * discount_percent *.01).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!