Question

Write SQL Commands for (a) to (e) and write the outputs for (f) to (h)on the basis of the following table :

(a) Create the above table with appropriate data types and constraints.
(b) To list the details of furniture whose price is more than 10000 in descending order of their price.
(c) To list the Item name and Price of furniture whose discount is between 10 to 20
(d) To delete the record of all item where discount is 30.
(e) Write a command to insert the last record which is mentioned in the above table.
(f) Select Distinct Type from Furniture;
(g) Select Max(Price) from Furniture where DateofStock>’2002-02-15’;
(h) Select Count(*) from Furniture where Discount<25;​

Answer 1

Answer:

descending order of their price.

(c) To list the Item name and Price of furniture whose discount is between 10 to 20

(d) To delete the record of all item where discount is 30.

(e) Write a command to insert the last record which is mentioned