mysql> select name,vorname,age from sortorder order by name asc,vorname asc ,age desc; 
+--------+-----------+------+
| name   | vorname   | age  |
+--------+-----------+------+
| Koeppe | Alexander |   21 |
| Koeppe | Herbert   |   44 |
| Koeppe | Katjana   |   43 |
| Koeppe | Katjana   |   42 |
| Lutz   | Herbert   |   44 |
+--------+-----------+------+
5 rows in set (0.02 sec)

mysql>