Database and Expert System Technology - Information Systems Reengineering, Integration and Normalization - page 47

• ToretrievetheaddressofalllecturerswhoteachCS101
Select Lecturer_address from Enroled_Student, Lecturer
where Enroled_Student.Lecturer_name =
Lecturer.Lecturer_name
• Listallstudent_nameandstudent#ofallstudentsorderedbystudent_name.The
default ordering is ascending lexiographic
• Listtheclass#,student#,andstudent_nameofallstudentsforeachclass
Select Class#, Student#, Student_name from
Student,Enroled_Student
where Student.Student# = Enroled_student.Student#
group by Class#
• Listallclass#,student#,andstudent_nameofallstudentsforeachclassand
whose grade is A
Select Class#, Student#, Student_name from
Student,Enrolled_Student
where Student.Student# = Enrolled_student.Student#
group by Class#
having Grade = 'A'