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
Which clauses must be present in this query? Select all that apply. Selecting an invalid option has negative marking.
SELECT Answer Question
FROM Answer Question
WHERE Answer Question
GROUP BY Answer Question
HAVING Answer Question
ORDER BY Answer Question
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
