Take-Home Final
Name .
You have 'Select' permission on these two tables - Orateacher.PREVIOUS
and Orateacher.NEXT. This
is due on Wednesday MIDNIGHT, May 21 2007
*Note: Paste your
queries also. To find GPA, use GRD
weight as following: A=4, B=3, C=2, D=1, F=0 and ignore all 19519o1421t other grades.
- Answer
the following questions using only the previous semester table.
- What
is the number of computers science courses (NOT sections) offered in the
previous semester? 10 Points. Hint: 21 Display a SQL Query.
- What
is the number of FEMALE students in the above computer science courses
from the previous semester? 10
Points.
- Find
the GPA for all courses under COMSC department and department gpa. 10 Points.
- Sort
the result (C above) in GPA descending order. 10 Points.
- Find
the GPA for all DVC departments. 10 Points.
- Find
the GPA for all DVC divisions. 10 Points.
- Find
the GPA for DVC. 10 Points.
- Display
the GPAs for DVC, Division, Department next to
each other, so I can compare them easily. 30 points. For
example, Select DVC_GPA, Division_GPA, Department_GPA
FROM My_previous;
- Find
the seat (row) counts based on above (Question G), who did not have one
of these grades- A, B, C, D or F. 10 Points.
- Answer
the following questions using both (previous and next) semester tables.
- What
is the number of distinctive computers science COURSES (NOT sections)
offered in BOTH semesters? 10 Points.
- What
is the number of MALE students in the above computer science courses from
the PREVIOUS semester ONLY, NOT NEXT semester? 10 Points.
- What
is the number of MALE students in the above computer science courses from
the NEXT semester ONLY? 10 Points.
- Answer
the following questions using both (previous and next) semester
tables.
- Combine
the both semester tables, and find all distinctive COURSES offered per department (not just comsc
department). 10 Points.
- Combine
the both semester tables, and find all numbers of students per department,
per course, per section. 10 Points.
Have a Safe, Enjoyable, Great Summer!
