(Solved) : 7 Repeat Question 6 Using Combination Inner Join Union Exists Note Exists Deal Students En Q38013016 . . . .

7

repeat question 6 using a combination of inner join, union andnot exists

(Note: Not exists will deal with the students who are notenrolled in any classes)

8

create a view. We want to find out whichcourses are being taken by the different students for all thosewhose age is greater than the average age. Give a listing of thecourse descriptions and student names (Inner join)

9

We want to find out the courses thateach student is not enrolled in.

Give a listing of the coursedescriptions, and the students (lname) who are not taking thatspecific course

(Use a cartesian product and union itwith a minus)

10

Use the