Difference: CSC210S2026Lab2 (2 vs. 3)

Line: 1 to 1

META TOPICPARENT	name="CSC210SylS2026"

SQL Lab 2

This lab uses the enrollment data.

Line: 20 to 20

Part B (using only joins) Do not use the word "join" in any sql statement

Display the title of each course you were enrolled in last semester
Display the all the rooms associated with the classes a student took in a specific semester (you get to pick which semester and which student)

Changed:

<
<

Find the names of all the instructors teaching in the Religion and Philosophy department last year.
Display your schedule from last fall
Display the name, email, and major of all students majoring last spring in one major of your choice.
Display the student id numbers of each of the students that you shared a class with last semester (no duplications)
Display the names of each of the students that you shared a class with last semester (no duplications)
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.

>
>

Find the names of all the instructors teaching Cybernetics department during the academic year of fall 2007.
Display a student's schedule with enough data to find the classes, etc. ordered by the semester taken.
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.
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)
Repeat the previous question but display the names instead (no duplications)
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