Register

MadeEasy Test Series: Databases - Sql

• edited by
645 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
878
878 views
amitqy asked Jan 8, 2019
878 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
997
997 views
pranab ray asked Dec 20, 2017
997 views
MadeEasy Test Series: Databases - Sql
3 3 votes
1 1 answer
1.3k
1.3k views
varun singh asked Feb 6, 2017
1,346 views
MadeEasy Subject Test: Databases - Sql