Difference: CSC210S2026Lab2 (3 vs. 4)

Revision 42026-01-16 - CathyBareiss

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

SQL Lab 2

This lab uses the enrollment data.

Line: 25 to 25
 
  1. Display the name, total credits, and major of all students advised by a faculty member in a department of your choice with the "newest" students first.
  2. For student 77588, display the student id numbers of each of the students that shared a class with him/her during the semester of Spring 2008 (no duplications)
  3. Repeat the previous question but display the names instead (no duplications)
Deleted:
<
<
  1. Find the names of all the instructors who have taught a course with the same course code as anyone who taught ENGL 101 last fall. --> needs fixing still
 \ No newline at end of file
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