Display faculty names in descending order by their department, but in alphabetical order by their name within each department.

Question

Write queries/statements for the following. (Use tables created in Chapter 4 Lab Activity.)

Answer 1

```
SQL> SELECT *
2 FROM faculty
3 ORDER BY DeptId DESC, Name;

FACULTYID NAME ROOMID PHO DEPTID
---------- --------------- ---------- --- ----------
555 Chang 17 587 5
444 Rivera 21 544 4
333 Collins 17 599 3
345 Sen 12 579 3
235 Vajpayee 12 577 2
222 Williams 20 533 2
111 Jones 11 525 1
123 Mobley 11 529 1

8 rows selected.
```