Question

Product

ProductID	ProductName	ProductCost	NumInInventory
1	China Plate	33.45	3
2	Book Shelf	24.54	2
3	Ladel	3.45	5
4	Paper Towel Holder	2.35	15
…..

Write the SQL for each of the following.

1. Select all products and all their details.

2. Select all the names of the products.

3. Select all products that cost more than $10.00.

4. Increase the cost of all products by 4%.

5. Insert a new product of your choice.

6. Delete all products that cost more than $200.

Answer 1

Select all products and all their details.

Query:

Select * from Product;

Select all the names of the products.

Query:

Select ProductName from Product;

Select all products that cost more than $10.00.

Query:

Select * from Product where ProductCost > 10;

Increase the cost of all products by 4%.

Query:

Update Product

set ProductCost = ProductCost + (4/100)*ProductCost;

Insert a new product of your choice.

Query:

Insert into Product values(5,'Pen',6.50,10);

Delete all products that cost more than $200.

Query:

Delete from Product where ProductCost > 200;