Register

MadeEasy Test Series: Databases - Sql

• edited by
649 views

1 Answer

Best answer
1 1 vote

(A) is the correct option!

Sum of marks in each department, if greater than equal to the average marks of all departments, department name will be in result set.

Only $d2$ will be selected!

• selected by
Voting & Accepting an answer helps improve the community
← Previous · regular or notNext → · Dynamic programming
← Previous in category · MadeEasy Test Series...Next in category → · ACE tesy
Position:
Show:

Related questions

0 0 votes
0 0 answers
879
879 views
amitqy asked Jan 8, 2019
879 views
MadeEasy Test Series: Databases - Sql
I got why query 2 is wrong. How do I approach to understand Query 1, is there a generic approach for solving questions like these which have no tables given?
1 1 vote
1 1 answer
658
658 views
sumit chakraborty asked Jan 26, 2018
658 views
MadeEasy Test Series 2018: Databases - Sql
0 0 votes
0 0 answers
999
999 views
pranab ray asked Dec 20, 2017
999 views
MadeEasy Test Series: Databases - Sql
3 3 votes
1 1 answer
1.4k
1.4k views
varun singh asked Feb 6, 2017
1,354 views
MadeEasy Subject Test: Databases - Sql