Question: Consider the Schema of the university database. Select SQL query to find the average salary of instructors in each department. classroom(building, room_number, capacity) department(dept_name, building,
Consider the Schema of the university database. Select SQL query to find the average salary of instructors in each department. 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, avg (salary) from instructor group dept name select dept name, avg (salary) as avg_salary from instructor group by dept name; select avg (salary) from instructor; select count (") from course
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
