Question

Write the SQL command for the following on the basis of given table. (i) To show all information about the Baby cots from the FURNITURE table.(ii) To list the ITEMNAME which are priced at more than 15000 from the FURNITURE table.(iii) To list ITEMNAME and TYPE of those items, in which DATEOFSTOCK is before 22/01/2002 from the FURNITURE table in descending order of ITEMNAME.(iv) To delete the records in which TYPE is sofa from FURNITURE table. 4 points

Answer 1

Answer:

(iv) is your answer..

Explanation:

HOPE IT HELPS YOU..

PLEASE MARK ME AS BRAINLIEST..