please i need help me answer each question in SQL statement.

Answer the following questions. Make sure you use comments in your SQL. file to clarity/show which SQL, statement is the answer to which question. The questions are: 1. Write a statement that shows employees whether they are President ot not, if the employee is the president, the statement shows President. otherwise Not President 2. Write a statement that shows 'US' it the office is in the US, otherwise 'not in the US:- 3. Write a statement that increases the buyPrice of products that start with $10 by 12% and the rest by 15%.. 4. Write a statement that increases the creditlimit of customers Itom the US by 20%6 and the rest of the world by 10%. 5. Write a statement that decreases the buyPrice of products that start with $10 by 10%,512 by 12%6,518 by 18%, and the rest by 20%. 6. Write a statement that decreases the buyPrice of products that their quantitylnStock is more than 5000 by 10%, the rest by 5%6. 7. Write a statement that decreases the quantityOrdered (in the table of orderdetails) by 2 wh tor products that starts with 518 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 caiculates total payments of customers. 9. White a statement to show yes if the customer with CustomerNumber 103 has paid more than the customer with CustomerNumber 112 ; otherwise no. 10. Write a statement to show yes it the product with ProductCode 510 _1678 is more expensive than the product with the ProductCode "S12. H108: otherwise no