Question: 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
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
Get step-by-step solutions from verified subject matter experts
