Product table, I need to create a procedure sp_ProductPriceCategory providing the product ID, product name, list price,
Fantastic news! We've Found the answer you've been seeking!
Question:
If the price is less than $150, the category is 'low'.
If the price is greater than $150 and the price is less than or equal to 450, the category is 'medium'.
If the price is greater than $450 and the price is less than or equal to 950, the category is 'med_high'.
If the price is greater than 950, the category is 'high'.
Show the procedure definition.
Execute the procedure, sp_ProductPriceCategory, with product IDs 836 and 841.
Related Book For
Corporate Finance
ISBN: 978-0077861759
10th edition
Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe
Posted Date: