# Database: University Example: Exercises: SELECT 3a

Name __________________________________________
These questions all apply to the University database.

1. (2 points) How many enrollments are there?
2. (2 points) List all courses (`crs_id`) that are in the 'PSYC' department (`dep_id`) and have less than three credits (`crs_credits`).
3. (2 points) List all students (last name then first name) in ascending order, who are taking courses in Rota (`edc_id`).
4. (3 points) List all the instructors that Ricky Klein has.
5. (3 points) List all instructors who are teaching either CMIS140 or CMIS240. Show their id, first name, last name, and the course they are teaching. Order the instructors by last name, then first name. Don't show duplicate rows (eg, if an instructor is teaching more than one section of a class).
6. (3 points) How many students are enrolled in CMIS240 in Iceland (`edc_id`)?