Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started