Saved Bookmarks
| 1. |
Write the output of the queries (a) to (d) based on the table, Furniture given below:FIDNAMEDATE OF PURCHASECOSTDISCOUNTB001Double Bed03-Jan-20184500010T010Dining Table10-Mar-202051000 5B004Single Bed19-Jul-2021220000C003Long Back Chair30-Dec-2016120003T006Console Table17-Nov-20191500012B006Bunk Bed01-Jan-20212800014(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"); |
|||||
|
Answer» (a) 29 (b) 19-Jul-2021 (c)
(d) 10-Mar- 2020 17-Nov-2019
|
||||||