# Database: University Example: Exercises: Joins 1

Name __________________________________________
These questions all apply to the University database.

1. List all the courses (crs_id) and the department names they are taught in.
2. Which Ed Centers (`edc_name`) are teaching IFSM410? Note that IFSM410 is a value in the `Section.crs_id` field. If an Ed Center is teaching more than one section of IFSM410, it should only be listed once.
3. Who's currently teaching? Give their id, last name and first name (ordered by last name and first names in ascending order). Assume that the Section table contains only sections that are currently being taught. Don't list instructors more than once even if they are teaching more than once.
4. Who's teaching in which Ed Centers in Germany? Give the Ed Center, instructor last name, and first name, all in ascending order. Germany is identified by an `edc_country` value of 'de'.
5. Which students are taking courses from Fred Swartz? Make your own decisions about what to display.