Yurttas/PL/DBL/postgres/F/01/Bank/o02.sql

 1/*
 2REM
 3REM o02.sql
 4REM
 5REM List the entire borrow relation in descending order of amount,
 6REM if several loans have the same amount, order them
 7REM in ascending order by loannumber.
 8REM
 9*/
10
11SELECT current_schema();
12SET search_path to "bank";
13
14SELECT *
15FROM Borrower
16ORDER BY amount DESC,
17	 loannumber ASC;