1) BBOTT University was established in the previous year and wants to create a database for internal usage. IT departmen

[answerhappygod]

1 Bbott University Was Established In The Previous Year And Wants To Create A Database For Internal Usage It Departmen 1 (106.32 KiB) Viewed 18 times

1) BBOTT University was established in the previous year and wants to create a database for internal usage. IT department of the university creates the following tables for the database: DEPARTMENT (Dept_name, Building, DeptBudget) COURSE (Course_id, Dept name. Title, Credits) INSTRUCTOR (Instructor_id, Dept_name, Name, Salary) SECTION (Course_id. Sec_id, Semester, Year, Building, Room_number, Time_slot_id) TEACHES (Instructor id. Course id. Sec id. Semester. Year) Write the following SQL queries. a) List the names of all instructors. b) List the department names of all instructors without duplication. c) List the ID, name and salary of all instructors. d) List the names of all instructors in the "Industrial Engineering" department who have salaries greater than £30000. e) List the names of all instructors along with their department names and department building name. f) List the names of all instructors in the "Mechanical Engineering department, order by ascending order. g) Show the average salary of instructors in the "Industrial Engineering" department. h) Show the total number of instructors who teach a course in the year 2018, Spring semester. i) List the departments where the average salary of the instructors is more than £25000. j) Show the average instructors' salaries of those departments where the average salary is greater than £28000.