$ psql -qXf table.sql 
 c1 | i2 | i3 
----+----+----
 a  | 23 | 11
 b  | 24 | 15
 c  | 16 | 19
 d  |  8 |  2
 e  | 40 | 41
(5 rows)

 c1 | i2 
----+----
 e  | 40
 b  | 24
 a  | 23
 c  | 16
 d  |  8
(5 rows)

 c1 | i3 
----+----
 e  | 41
 c  | 19
 b  | 15
 a  | 11
 d  |  2
(5 rows)

 c1 | rank | rank 
----+------+------
 a  |    3 |    4
 b  |    2 |    3
 c  |    4 |    2
 d  |    5 |    5
 e  |    1 |    1
(5 rows)