I need help with bonus tasks only! Nested Queries. I have the tables in the first picture created, but have not been able to complete the bonus questions.

Bonus Task: Nested Queries $(10$ marks$)$

For this bonus task, you will need to write nested queries to answer more complex questions.

Each query should demonstrate your understanding of how to use subqueries effectively in SQL$.$

Bonus Task $1$: Find Students Who Have Taken All Courses in a Specific Department $(5$

marks$)$

Write a query to find all students who have taken all the courses offered by the 'Comp. Sci.$\text{'}$

department.

Hint: Use a nested query to first select all the courses from the 'Comp. Sci.$\text{'}$ department,

and then compare it with the courses that each student has taken.

Bonus Task $2$: Find Courses with Enrollment Greater Than the Average Enrollment $(5$

marks$)$

Write a query to find all courses that have an enrollment greater than the average enrollment of

all courses.

Hint: Use a nested query to compute the average enrollment first, and then compare it

with the enrollment of each course.