Question: need help writing SQL query. for Data & Information Management. Answer the following questions. Make sure you use comments in your SQL file to clarify/show

need help writing SQL query. for Data & Information Management.
need help writing SQL query. for Data &
Answer the following questions. Make sure you use comments in your SQL file to clarify/show which SQL statement is the answer to which question. The questions are: 1- Write a SQL query to delete customers from the UK and France. 2. Write a SQL query to increase the buyprice of products by %10. 3- Write a SQL query to increase the number of quantityOrdered of product 'S18_4409' in orderNumber 10407 from 6 to 12. 4- Write a SQL query to change the amount of the check 'HQ336336' to 1200. 5. Write a SQL query to change the contact number of customer 103 to 40.22.2455 6.Write a SQL query to delete employees with ID 1056 and 1076. 7.Write a SQL query to delete customers who have not placed any orders. 8-Write a SQL query to delete products that have not been ordered by any customers. 9. Write a SQL query to change buyprice and quantitylnStock of the product with ID S10.1949 to 52 and 500 , respectively. 10-Write a SQL query to increase buyprice of products that start with S10 by 10%

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 General Management Questions!