Write the output of the queries (a) to (d) based on the table, Furniture given below:
FID |
NAME |
DATE OF PURCHASE |
COST |
DISCOUNT |
B001 |
Double Bed |
03-Jan-2018 |
45000 |
10 |
T010 |
Dining Table |
10-Mar-2020 |
51000 |
5 |
B004 |
Single Bed |
19-Jul-2021 |
22000 |
0 |
C003 |
Long Back Chair |
30-Dec-2016 |
12000 |
3 |
T006 |
Console Table |
17-Nov-2019 |
15000 |
12 |
B006 |
Bunk Bed |
01-Jan-2021 |
28000 |
14 |
(a) SELECT SUM(DISCOUNT)
FROM FURNITURE
WHERE COST>15000;
(b) SELECT MAX(DATEOFPURCHASE)
FROM FURNITURE;
(c) SELECT * FROM FURNITURE
WHERE DISCOUNT>5 AND FID LIKE "T%";
(d) SELECT DATEOFPURCHASE FROM FURNITURE
WHERE NAME IN ("Dining Table", "Console Table");