Buildings named by rooms or departments

Produce a combined list of building names: every building value that appears in the classroom table, followed by every building value that appears in the department table. Keep all duplicates (a building used by several classrooms, or listed in both tables, appears multiple times).

Return one column: building, sorted alphabetically (ascending).

---

Database schema

−+Fit
primary keyforeign keyarrow points to the referenced columndrag to pan