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.
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
