1. SQL allows the user to control the order in which tuples are displayed.

• order by makes tuples appear in sorted order (ascending order by default).
• desc specifies descending order.
• asc specifies ascending order.

select *
from loan
order by amount desc, loan# asc

Sorting can be costly, and should only be done when needed.