- Find the titles of courses in the Comp. Sci. department that have 3 credits.
- Find instructor pairs such that both instructors in a pair have the same salary.
- For each instructor, their name, their salary, and the number of instructors who earn more than they do.
- Find
the names of all students who have taken at least one Comp. Sci.
course. Make sure there are no duplicate names in the result.
- Find the ids of all students who were taught by an instructor named Einstein; make sure there are no duplicates in the result.
- Find the names of all students who were taught by an instructor named Einstein; make sure there are no duplicates in the result.
- How many instructors work at the university
- Department names and the number of people in that department.