Question

Consider the table: ITEM

                                  Table: ITEM

SNo	Itemname	Type	Price	Stockdate
1	Chaises	Living	11500.58	2020-02-19
2	Accent Chairs	Living	31000.67	2021-02-15
3	Baker Racks	Kitchen	25000.623	2019-01-01
4	Sofa	Living	7000.3	2020-10-18
5	Nightstand	Bedroom	NULL	2021-07-23

Write SQL queries for the following:

1. Display all the records in descending order of Stockdate.
2. Display the Type and total number of items of each Type.
3. Display the least Price.
4. Display the Itemname with their price rounded to 1 decimal place. 

Answer 1

1. SELECT * FROM ITEM ORDER BY Stockdate DESC;
2. SELECT Type, COUNT(Itemname) FROM ITEM GROUP BY Type;
3. SELECT MIN (Price) FROM ITEM;
4. SELECT Itemname, ROUND (Price, 1) FROM ITEM;