Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Product table, I need to create a procedure sp_ProductPriceCategory providing the product ID, product name, list price, and list price category where the product IDs

Product table, I need to create a procedure sp_ProductPriceCategory providing the product ID, product name, list price, and list price category where the product IDs are between two product IDs to be entered by the users. The list price category is defined as in the following:

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Finance

Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe

10th edition

978-0077511388, 78034779, 9780077511340, 77511387, 9780078034770, 77511344, 978-0077861759

More Books

Students also viewed these Databases questions

Question

differentiate the function ( x + 1 ) / ( x ^ 3 + x - 6 )

Answered: 1 week ago