Question

Write the SQL commands to answer the queries based on following table
"Furniture".
Item_code
Item_Number
Table
Chair
Cupboard
Table
Chair
Type
Wooden
Plastic
Wooden
Iron
Iron
Price
5000
500
12000
7000
800
a. Display the details of all wooden furniture
b. Insert a new record for a wooden cupboard of price 13650
C. Delete all the records of items whose price is less than 900
d. Change the price of a plastic chair to 600
e. Identify the primary key for the above table.​

Answer 1

Answer:

furniture

item code

table

chair cupboard wooden plastic

pls follow me