Q1: Find the titles and
instructors of all CS courses
Q2: All student names and GPAs who live on
Wilshire
Q3: Find all student names
who take CS classes.
Q4: All names of students
and instructors
Q5: Find the names of pairs of students who
live on the same addr
Q6: Find students taking at least two classes
Q7: Find all student names
who take all CS classes (offered this quarter)
Q8: Find the names of students
who is taking no CS classes
Q9: Find the ids of students
whose GPA is greater than all
Q10: Find the names and GPAs
of all students taking CS classes
Q11: Find the names of students
whose GPA is higher than some
Q12: Find the names of students
who GPA have the lowest GPA
Q13: Find the average GPA.
Q14: The number of students
taking CS classes
Q15: The average GPA of the
students taking CS classes
Q16: Find the average GPA
for each age group
Q17: Find the number of classes
each student is taking
Q18: Find students who are
taking exactly two classes.