The Question : Write the output of the queries
A) to
D) based on the table, Furniture given below:
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”);
Solution for the question :
(a) 29 (b) 19-Jul-2021 (c) T006Console Table17-Nov 20191500012(d) 10-Mar- 2020 17-Nov-2019
The correct answer to the question is researched by our moderators and shared with you. You can give feedback by commenting for the answers you think are wrong.