Consider the following schema: instructor(ID, name, dept_name, salary) department(dept_name, building, college, budget) What is the correct SQL statement to perform a query to find the names and average salaries of departments in the college of ‘Science’ whose average salary is greater than 75000?
Consider the following schema:
instructor(ID, name, dept_name, salary)
department(dept_name, building, college, budget)
What is the correct SQL statement to perform a query to find the names and average salaries of departments in the college of ‘Science’ whose average salary is greater than 75000?
(a) select dept_name, avg (salary)
from instructor natual join department
having college = ‘Science’
group by dept_name
where avg (salary) > 75000;
(b) select dept_name, avg (salary)
from instructor natual join department
where college = ‘Science’
group by dept_name
where avg (salary) > 75000;
(c) select dept_name, avg (salary)
from instructor natual join department
where college = ‘Science’
group by dept_name
having avg (salary) > 75000;
(d) select dept_name, avg (salary)
from instructor natual join department
having college = ‘Science’
group by dept_name
having avg (salary) > 75000;
(e) select dept_name, avg (salary)
from instructor natual join department
where college = ‘Science’
and avg (salary) > 75000
group by dept_name;
Trending now
This is a popular solution!
Step by step
Solved in 2 steps