Display faculty names in descending order by their department, but in alphabetical order by their name within each department.
Write queries/statements for the following. (Use tables created in Chapter 4 Lab Activity.)
```
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.
```
You might also like to view...
Stacks are _____________ data structures.
a) FIFO b) Random c) LIFO d) None of the above.
A(n) ___________is a bit-for-bit copy of the data from all sectors of a hard disk.
Fill in the blank(s) with the appropriate word(s).