Question: Consider the Schema of the university database. Select SQL query to find the average salary of instructors in those departments where the average salary is

Consider the Schema of the university database. Select SQL query to find the average salary of instructors in those departments where the average salary is more than $42,000 classroom(building, room_number, capacity) department(dept_name, building, budget) course(course id, title, dept name, credits) instructor(ID, name, dept_name, salary) section(course_id, sec_id, semester, year, building, room_number, time_slot id) teaches(ID, course id, sec id, semester, year) student(ID, name, dept_name, tot cred) takes(ID, course id, sec id, semester, year, grade) advisor(s ID, i_ID) time_slot(time_slot_id, day, start_time, end_time) prereq(course_id,_prereq_id) select dept_name, from department having avg (salary) > 42000; select instructor_ID, avg (salary) from instructor group by instructor having avg (salary) >42000; select dept_name, avg (salary) from instructor group by dept_name having avg (salary) >42000; select dept_name, avg (salary) from department group by salary having avg (salary) >42000

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 General Management Questions!

Do not answer if you cannot answer all of them. Problem 2. Answer 2.1-2.3 using university schema classroom (building, room number, capacity) department (dept name, building, budget) course (course...

/*Please answer the Queries and display the code and output.*/ This assignment focuses on the use of the aggregate functions. These functions combine all the results to perform a statistical...

Database Questions 1. Find the ids of instructors who are also students using a set operation . Assume that a person is identified by her or his id. So, if the same id appears in both instructor and...

Database questions. Needs to be in SQL Oracle. 1. Find the names and ids of the students who have taken exactly one course in the Spring 2010 semester. 2. Find the names and ids of the students who...

Query 1 (2 pts) Write a query that outputs another version of table of prerequisites, where courses are represented by their titles, not by their IDs. In the resulting table, rename the columns...

**THE FOLLOWING IS THE ddl.sql SCHEMA*** create table classroom (building varchar(15), room_number varchar(7), capacity numeric(4,0), primary key (building, room_number) ); create table department...

Problem 2 (Part a is 2 points, parts b-c are 3 points each; total is 8 points) Write SQL statements that define the following views. Make sure that all columns in each view's results have meaningful...

Use the Schema: CREATE TABLE classroom (building varchar(15), room_number varchar(7), capacity numeric(4,0), primary key (building, room_number) ); CREATE TABLE department (dept_name varchar(20),...

Solve the following questions using Oracle . You are not allowed to use the syntax of any DBMS other than Oracle. 1. Find the names and ids of the students who have taken all the courses that are...

SQL (10 pts.) Database creation and querying exercise. The schema, DDL, and instance for the University database from the textbook are provided in Appendix A. The electronic form of the DDL and...

Employment in the XYZ industry is 100,000 in the town. Employment in the state is 1,600,000. National Employment in the XYZ industry is 5,000,000. Total employment in the country is 100,000,000. a....

Study Rev. Proc. 98-25, and answer the following questions: a. Briefly describe the procedure's contents and topic. b. What effect does the procedure have on prior revenue procedures? c. Is the...

Please help with CapSIm email: a . 6 8 6 8 units b . 3 8 0 1 units c . 7 8 4 8 units d . 3 4 3 4 units

Create a C# application named SalesTransactionDemo that declares several SalesTransaction objects and displays their values and their sum. The SalesTransaction class contains the following fields:...