Question: 1. Write a query to Display the product details (product_class_code, product_id, product_desc, product_price,) as per the following criteria and sort them in descending order of

1. Write a query to Display the product details (product_class_code, product_id, product_desc, product_price,) as per the following criteria and sort them in descending order of category: a. If the category is 2050, increase the price by 2000 b. If the category is 2051, increase the price by 500 c. If the category is 2052, increase the price by 600. Hint: Use case statement. no permanent change in table required. (60 ROWS) [NOTE: PRODUCT TABLE]

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 Mathematics Questions!

Q:

1. Write a query to Display the product details (product_class_code, product_id, product_desc, product_price,) as per the following criteria and sort them in descending order of category: a. If the...

Q:

1 . Write a query to Display the product details (product_class_code, product_id, product_desc, product_price,) as per the following criteria and sort them in descending order of category: a. If the...

Q:

1 . Write a query to Display the product details (product_class_code product_id , product_desc product_price ) as per the following criteria and sort them in descending order of category : a. If the...

Q:

1 . Write a query to Display the product details (product_class_code, product_id, product_desc, product_price,) as per the following criteria and sort them in descending order of category: a. If the...

Q:

1 . Write a query to Display the product details (product_class_code, product_id, product_desc, product_price,) as per the following criteria and sort them in descending order of category: a. If the...

Q:

The structure and contents of the Ch07_LargeCo database are shown in Figure P7.27 . Use this database to answer the following problems. 27. Write a query to display the eight departments in the...

Q:

The structure and contents of the Ch07_LargeCo database are shown in Figure P7.27 . Use this database to answer the following problems. 27. Write a query to display the eight departments in the...

Q:

1. Write a query that displays the Company Name (customer) and the number of orders each customer has. Write a query that displays the Company Name (Customer Name) and the grand total amount in...

Q:

2 . Write a query to display the following information for the products, which have not been sold: product _ id , product _ desc, product _ quantity _ avail, product _ price, inventory values (...

Q:

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

Q:

Use Theorem 4.7 to evaluate E (2XY2 X2Y) for the joint probability distribution shown in Table 3.1.

Q:

In Fig. 33-51, light is incident at angle θ1 40.1 on a boundary between two transparent materials. Some of the light travels down through the next three layers of transparent materials,...

Q:

15.55 Household sizes for the households participating in the 1996 General Social Survey conducted by the National Opinion Research Center at the University of Chicago are shown in the following...

Q:

REVIEW THE INFORMATION ABOUT LEAPFROG HOSPITAL SAFETY GRADES. CHOOSE TWO HOSPITALS TO COMPARE A VERY EFFECTIVE ONE AND ONE WHICH IS NOT EFFECTIVE. WHAT SEPARATES THE TWO? HOW CAN THE A HOSPITAL USE...

Q:

Competence: What knowledge, skills and attitude do I have towards what I am going to do?

Q:

1. Imagine a real situation in your workplace or home situation, where you have given another person feedback on something he has done. a. What was your intention? b. How was the feedback perceived?...

Q:

Behaviour: What am I doing?