Find the total number of enrollment across all sections, considering only sections that have some enrollment, don't worry about the sections that have no students taking them.
As in in Q1, but now also include sections with no students taking them; the enrollment for such sections should be treated as 0. Do this by using aggregation on a left outer join (use the SQL left outer join syntax).
Find the maximum and minimum enrollment across all sections, considering only sections that have some enrollment, don't worry about those that had no students taking that section.
Find the maximum and minimum enrollment across all sections, include sections with no enrolments (as in Q2).
Find all sections that had the maximum enrollment (along with the enrollment), using a subquery.
Find all courses whose identifier starts with the string "CS-1".
Update the salary of each instructor to 10000 times the number of course sections they have taught.
Insert each instructor as a student, with tot_creds = 0, in the same department.
Now delete all the newly added "students" above (note: already existing students who happened to have tot_creds = 0 should not get deleted. Think that the newly added students are the instructors from the instructors’ table.)
Some of you may have noticed that the tot_creds value for students did not match the credits from courses they have taken. Write and execute query to update tot_creds based on the credits passed, to bring the database back to consistency

1.  

Transcribed Image Text:

section Course id sec id semester year building TOOM_NO time_slot_id classroom building room no capacity takes ID course id sec_id semester grade time_slot time slot id day start time end_time teaches ID course id sec id semester year course course id title dept name credits prereq course id prereq id student ID FUATI dept_name fol_cred department dept_name building budget instructor ID name dept_name salary advisor id section Course id sec id semester year building TOOM_NO time_slot_id classroom building room no capacity takes ID course id sec_id semester grade time_slot time slot id day start time end_time teaches ID course id sec id semester year course course id title dept name credits prereq course id prereq id student ID FUATI dept_name fol_cred department dept_name building budget instructor ID name dept_name salary advisor id

Answer rating: 100% (QA)

1 Total Number of Enrollment Across All Sections The total number of enrollment across all sections can be found using a left outer join A left outer join combines the records of two tables based on a ... View the full answer