CS $340-$ Introduction to Database Systems

mark$]$ Display the faculty ID who have taught or teaching all the courses as faculty Philip Brown.

$[0\mathrm{.}5$ mark$]$ Display student ID$,$ name, Course Code, Course Title, Course Section ID$,$ Grade of the enrolled students. Also display the students who are not enrolled in any course.

$[0\mathrm{.}5$ mark$]$ Create a view and display the Student, Name, class who has the same advisor as "Sarah Miller". $($Use IN operator in a non$-$correlated sub$-$query$).$

$[0\mathrm{.}5$ mark$]$ Display the course Code, Course Title, course section and the total number of instructors$($faculty$)$ teaching each course. Use the column Heading "Number of Instructors" for the aggregate field. Display only those courses where the number of instructors$($faculty$)$ are $3$ or more. $($Use an appropriate aggregate function and GROUP B clause.$)$