answer following questions with SQL statements.

5. Write a statement that decreases the buyPrice of products that start with S10 by 10%,S12 by 12%,S18 by 18%, and the rest by 20% 6. Write a statement that decreases the buyPnce of producis that their quantityinstock is mote than 5000 by 10%, the rest by 5% 7. Wrte 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 aro equal to or more than 30,000 by 'paid 30K or abovo, otherwise 'paid less than 30k ' Hint. First, find the total payments of each customer (using group by) and then put the statoment as the subguery that applies the CaSE Statement on the column that calculates total payments of customers 9. Write a statement to show yes it the customer with CustomerNurnber 103 has paid more than the customer with CustomerNumber 112 , othenwise no 10. Wite a statement to show yes if the product with ProductCode S10_ 1678 is more expensive than the product with the ProductCade 'S12_ 1106\%: otherwise no