mysql> select name, marks, address from student order by name,
marks desc;
+---------+-------+------------------+
| name    | marks | address          |
+---------+-------+------------------+
| anne    |   100 | downing street   |
| anne    |    80 | edinburgh        |
| david   |    98 | welling street   |
| jack    |    82 | victoria street  |
| michael |    75 | edinburgh        |
| mille   |    98 | victoria street  |
| steve   |   100 | 5th cross street |
| steve   |    75 | downing street   |
+---------+-------+------------------+
8 rows in set (0.00 sec)