Difference: CSC210S2026Lab3 (3 vs. 4)

Revision 42026-01-21 - CathyBareiss

Line: 1 to 1
 
META TOPICPARENT name="CSC210SylS2026"

SQL Lab 3

This lab uses the enrollment data.

Line: 25 to 25
 
  1. Display the ids of all students who took a course during the fall of 2009 but not the spring.
Part C (use any method you wish)
  1. The names of the instructors that have taught the largest number of different students in a given semester
Deleted:
<
<
  1. The names of the students who have taken the largest load in a given semester
  2. The names of the instructors who have taught (in a given semester) less courses than the average number of courses taught by any instructor in the same semester (i.e. multiple sections of the same course don't count). Order by the count and then the name for extra credit.
 \ No newline at end of file
Added:
>
>
  1. The names of the students who have taken the largest load in a during the fall of 2006. Include the number of hours the student took that semester.
  2. The department with the highest average salary of its faculty
View topic | History: r4 < r3 < r2 < r1 | More topic actions...
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2026 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback