Question: onsider the following schema: Emps ( EID , EName, Sal, DNo ) Depts ( DNum , DName, Loc, MID ) DNo references to DNum while

onsider the following schema:
Emps (EID, EName, Sal, DNo)
Depts (DNum, DName, Loc, MID)
DNo references to DNum while MID referencess to EID.
We want to write a query that can produce a list of all DName along with the corresponding average Sal but where the average is above 10000.
Which clause(s) must be present in this query? Select all that apply. Selecting an invalid option has negative marking.
SELECT Answer 1 Question 2
FROM Answer 2 Question 2
WHERE Answer 3 Question 2
GROUP BY Answer 4 Question 2
HAVING Answer 5 Question 2
ORDER BY Answer 6 Question 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!