ITM 500 Chapter 9: week9.docx
Document Summary
-example 1 show the details for students enrolled in more. Select * from student where stdssn in (select stdssn from enrollment. Select * from student where stdgpa > (select avg(stdgpa) from student) -example 3 list the details of the faculty of the. -assistant rank who earn more than average salary. Select * from faculty where facrank = "asst" and facsalary > (select avg(facsalary) from faculty where facrank = "asst") -example 3a unbalanced conditions would give erroneous answers. Select * from faculty where facrank = "asst" and facsalary > (select avg(facsalary) from faculty ) -example 3b unbalanced conditions would give erroneous answers. Select * from faculty where facsalary > (select avg(facsalary) from faculty where facrank = "asst") -example 4 list the details of the student with the highest gpa. Select * from student where stdgpa = (select max(stdgpa) from student) List the enrollment details for the student morales Select e. * from enrollment e inner join student s.