CS143 Queries

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 (offered this quarter)

 

Q9: Find the ids of students whose GPA is greater than all students taking CS classes

 

Q10: Find the names and GPAs of all students taking CS classes

 

Q11: Find the names of students whose GPA is higher than some other student.

 

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.