This preview shows pages 1–2. Sign up to view the full content.
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
This note was uploaded on 10/03/2011 for the course MIS 235 taught by Professor Sunrro during the Fall '08 term at Miami University.
- Fall '08