Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
2.8k views
in Computer by (38.9k points)
closed by

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");

1 Answer

+1 vote
by (36.7k points)
selected by
 
Best answer

(a) 29 

(b) 19-Jul-2021 

(c) 

T006 Console Table 17-Nov2019 15000 12

(d) 10-Mar- 2020 

     17-Nov-2019

 

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...