This is the Schema:
These are the questions(SQL statements):
1.The SID, first name, last name, and number of classes taken for every student. As before, name your count column as NumOfClasses. Don't bother including students that have taken no classes.
2.The SID and grade for all enrollment records for the course with IndexNum 1001 offered in the term 'Fall 02'.
3.The SID, first name, last name, and grade for all enrollment records for the course with IndexNum 1001 offered in the term 'Fall 02'.
4.The course number, course name, term, instructor, credits, and grade for all courses taken by student 223451. Courses should be listed in order by term and within term by the course number.
5. The faculty name, course number, days, start time, ending time, and location for all course sections offered in the term 'Spring O3' in order by faculty name.
6.The SID of all students that have not yet taken a course.
7.The SID of every student that has taken both 'ACTG 313' and 'ACTG 314'. (even if they haven't been assigned a grade yet in one of them)
8.The FID, name, and number of classes taught (renamed as NumOfClasses) for all faculty members that have taught more than 5 courses.
Any help would be appreciated. Owe ya one!
This post has been edited by absynthe: 22 March 2009 - 09:42 AM