Data Mgmt Lab_Part_16 - 46 Chapter 5 5 Find the names of...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 46 Chapter 5 5. Find the names of faculty members who teach in every room in which some class is taught. 6. Find the names of faculty members for whom the combined enrollment of the courses that they teach is less than five. 7. For each level, print the level and the average age of students for that level. 8. For all levels except JR, print the level and the average age of students for that level. 9. For each faculty member that has taught classes only in room R128, print the faculty member’s name and the total number of classes she or he has taught. 10. Find the names of students enrolled in the maximum number of classes. 11. Find the names of students not enrolled in any class. 12. For each age value that appears in Students, find the level value that appears most often. For example, if there are more FR level students aged 18 than SR, JR, or SO students aged 18, you should print the pair (18, FR)....
View Full Document

{[ snackBarMessage ]}

Page1 / 3

Data Mgmt Lab_Part_16 - 46 Chapter 5 5 Find the names of...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online