a) SELECT SUM(DISCOUNT) FROM FURNITURE WHERE COST>15000;
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");
16 views
1 Answers
(a) 29
(b) 19-Jul-2021
(c)
| T006 | Console Table | 17-Nov2019 | 15000 | 12 |
(d) 10-Mar- 2020
17-Nov-2019
16 views
Answered