Exercise Database IT 7

Write an SQL query to find the total number of students enrolled in each department. Column Showed: dept_name and total_students

Clue: use JOIN and AS

Construct an SQL query to display the department name and the number of courses offered by each department.

Create an SQL statement to list the names of instructors along with the titles of the courses they teach for the Spring 2018 semester.

Create an SQL query to retrieve the names of all students who have taken more courses than the average number of courses taken by students in the Comp. Sci. department.

Write an SQL command to find the course ids of courses that have prerequisites and are taught in the Watson building.

Write an SQL query to update the budget of the Physics department to be the average budget of all departments.

Write an SQL query to find all courses taught by Srinivasan that occur on Mondays and Wednesdays.

Create an SQL query to list each course along with the number of sections, ordered by the number of sections from highest to lowest.

Write an SQL statement to add a new course ensuring it does not conflict with existing course ids and adheres to the prerequisite relationships.

Formulate an SQL query to find the department with the highest average salary for its instructors.