Write the output of the queries (a) to (d) based on the table, Furniture given below:
Table: FURNITURE
FID |
NAME |
DATE OF PURCHASE |
COST |
DISCOUNT |
B001 |
Double Bed |
03-Jan-18 |
45000 |
10 |
T010 |
Dining Table |
10-Mar-20 |
51000 |
5 |
B004 |
Single Bed |
19-Jul-21 |
22000 |
0 |
C003 |
Long Back Chair |
30-Dec-16 |
12000 |
3 |
T006 |
Console Table |
17-Nov-19 |
15000 |
12 |
B006 |
Bunk Bed |
01-Jan-21 |
28000 |
14 |
(a) SELECT SUM(DISCOUNT)
FROM FURNITURE
WHERE COST>15000;
Answer
29
(b) SELECT MAX(DATE OF PURCHASE)
FROM FURNITURE;
Answer
19-Jul-2021
(c) SELECT * FROM FURNITURE
WHERE DISCOUNT>5 AND FID LIKE "T%";
Answer
FID |
Name |
Date of purchase |
Cost |
Discount |
T006 |
Console Table |
17-Nov-19 |
15000 |
12 |
(d) SELECT DATE OF PURCHASE FROM FURNITURE
WHERE NAME IN ("Dining Table", "Console Table");
Answer
10-Mar- 2020
17-Nov-2019
![Slide17.JPG](https://d1avenlh0i1xmr.cloudfront.net/614f1d0a-6be6-415a-b7a9-b7b4adbc94b9/slide17.jpg)
![Slide18.JPG](https://d1avenlh0i1xmr.cloudfront.net/2a4e3913-6c15-46dd-8d6e-944327afdc1a/slide18.jpg)
![Slide19.JPG](https://d1avenlh0i1xmr.cloudfront.net/b51b753e-ad99-4d1d-95aa-4cc05bca77c1/slide19.jpg)
![Slide20.JPG](https://d1avenlh0i1xmr.cloudfront.net/175ba63c-511f-410d-a911-9474ba9118e4/slide20.jpg)
![Slide21.JPG](https://d1avenlh0i1xmr.cloudfront.net/59f0ed20-1628-4926-a355-eed78e4172e5/slide21.jpg)
![Slide22.JPG](https://d1avenlh0i1xmr.cloudfront.net/6cfbc8b5-b4c9-4235-9d90-25843a3225e3/slide22.jpg)