Database Reference
In-Depth Information
14. By using the EXISTS operator, execute an SQL statement to display the irst names and last
names of the students who are enrolled in the ISC2301 class.
15. By using the NOT EXISTS operator, execute an SQL statement to display the names of the
courses not required by the Database course.
16. By using an inner join, display the students' names along with their faculty advisors' names.
17. By using the RIGHT OUTER JOIN operator, execute an SQL statement to display classes
and semesters to see if any of the semesters in which no class is ofered.
18. By using a self-join, display the names of students who have enrolled in more than one class.
19. Find out how many students are advised by each faculty member.
20. By using the HAVING clause, display the last names of the students who have enrolled in
more than one class and display how many classes the students have been enrolled.
Search WWH ::




Custom Search