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) 

T006Console Table17-Nov20191500012

(d) 10-Mar- 2020 

     17-Nov-2019

 



Discussion

No Comment Found

Related InterviewSolutions