1. Rename: a mechanism to rename both relations and attributes.

2. as-clause can appear in both the select and from clauses:old-name as new-name.

3. Example.

select distinct cname, borrower.loan# as loan id
from borrower, loan
where borrower.loan# = loan.loan# and bname="SFU"