This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: FROM faculty fac, faculty, super WHERE fac.f_id= super.f_id; Find last name, first name of those students who are taking the same class as Daniel black SELECT s_class FROM student WHERE s_last= ‘Black’ and s_first= ‘Daniel’ SELECT s_last, s_first FROM student WHERE s_class = (SELECT s_class FROM student WHERE s_last= ‘Black’ and s_first= ‘Daniel’); SELECT f_last, f_first, f_phone FROM faculty union Select s_last, s_first, s_phone From student Name of courses taken only by students who are not seniors during term 6 SELECT DISTINCT course.name FROM course, course.section, enrollment, student WHERE course.course_id= course_section.course_id AND course_section.c_sed...
View Full Document
- Fall '08
- Sarah Miller, SELECT f_last