Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

5. Write a statement that updates products that start with S10 by 12% and the rest by 15% 6. Write a statement that decreases the

image text in transcribed
5. Write a statement that updates products that start with S10 by 12% and the rest by 15% 6. Write a statement that decreases the buyPrice of products that their quantityInStock is more than 5000 by 10%, the rest by 5%. 7. Write a statement that decreases the quantityOrdered in the table of orderdetails) by 2% for products that starts with S18 and for the rest of the products by 1%. 8. Write a statement that customers who their total payments are equal to or more than 30,000 by "paid 30K or above', otherwise "paid less than 30k'. Hint. First, find the total payments of each customer (using group by) and then put this statement as the subquery that applies the CASE Statement on the column that calculates total payments of customers. 9. Write a statement to show yes if the customer with CustomerNumber 103 has paid more than the customer with Customer Number 112, otherwise no. 10. Write a statement to show yes if the product with ProductCode 810_1678 is more expensive than the product with the Product Code 'S12_1108 otherwise no

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Fundamental Financial Accounting Concepts

Authors: J.K.

7th Edition

B003NPRW7I

More Books

Students also viewed these Accounting questions

Question

What is the relationship between humans and nature?

Answered: 1 week ago