Difference: CSC210S2024Lab3 (2 vs. 3)

Revision 32024-02-15 - CathyBareiss

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

SQL Lab 3

This lab uses the enrollment data.

Line: 22 to 22
 
  1. Display the ids of all students who are ready for but have not taken ENGL 102 (i.e. have taken ENGL 101)
  2. Display the ids of all students who have taken both ENGL 101 and THEO 110
Part C (use any method you wish)
Changed:
<
<
  1. The names of the instructors that have taught the largest number of different students last semester. extra credit: for each semester)
>
>
  1. The names of the instructors that have taught the largest number of different students last semester. Do not include Kristen Richmond. (extra credit: for each semester)
 
  1. The names of the students who have taken the largest load last spring
  2. The names of the instructors who have taught (last fall) less courses than the average number of courses taught by any instructor last fall (i.e. multiple sections of the same course don't count). Order by the count and then the last name for extra credit.
\ No newline at end of file
View topic | History: 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