UNSW wants to know the most popular subjects. Define a SQL viewQ8(subject) that lists the most popular subjects. A subject is oneof the most popular subjects if there are at least 20 distinctstudents enrolled (via the Course_enrolments table) in at least 20distinct courses offerings of the subject. Each tuple in the viewshould contain the following: ⚫ the subject code (Subjects.codefield) and name (Subjects.name field), in the format e.g. COMP9311Database Systems (Note that there is a space between subject codeand name) Note: ⚫ Some course offerings have no students enrolledin. It appears in Courses, but not in Course_enrolments.
Solution