Question: 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

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 quantityInStock 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!

Q:

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...

Q:

1- Show the first name and last name of customers. SELECT CustFirstName,CustLastName FROM customers; Don't forget to select the database SalesOrder before running the SELECT statement. You can select...

Q:

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 an SQL query to show the...

Q:

1- Write an SQL query to show the CustomerName and Country of Customers. 2- Write an SQL query to show all Countries (no duplicates), order them alphabetically. 3- Write an SQL query to show the...

Q:

What is MySQL? How do you install MySQL? How do you create a new database in MySQL? What is a table in MySQL? How do you create a new table in MySQL? How do you add a column to an existing MySQL...

Q:

homework. 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 an SQL query to...

Q:

1- Write an SQL query to show the age of each employee. 2- Write an SQL query to show the CustomerName and the complete address of each customer (the statement should return only two columns;...

Q:

Table of Customers: 1- Write a SQL statement that shows customers that are coming from the USA, France, and Norway 2- Write a SQL statement that shows customers that their credit limit is in the...

Q:

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 an SQL query to show...

Q:

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: Table of Customers: 1 - Write a...

Q:

Determine the current gain for the CE emitter-bias network of Fig. 5.156. o 20 V 2.2 k2 390 k2 = 140

Q:

For each of the following variables, indicate the level of data measurement: a. Product rating {1 = excellent, 2 = good, 3 = fair, 4 = poor, 5 = very poor} b. Home ownership {own, rent, other} c....

Q:

Which costing method ( s ) are allowed by GAAP to value inventory and cost of goods sold?

Q:

Your Portfolio Paper should concern a major MANAGERIAL DECISION AREA that would be made within a firm. It is suggested, but not necessary, that this decision area would be one in which you have...