在MySQL中，我們可以使用ORDER BY子句來根據一張表排序。

例如，我們有一個名為customers的表，其中包含了客戶的姓名、訂單數和訂單總額：

mysql>SELECT * FROM customers;
+----+-----------+----------+---------------+
| id | name      | orders   | total_amount  |
+----+-----------+----------+---------------+
| 1  | Jack      | 5        | 1000          |
| 2  | Lily      | 3        | 800           |
| 3  | Mike      | 10       | 1500          |
| 4  | Tom       | 8        | 1200          |
| 5  | Sarah     | 4        | 600           |
+----+-----------+----------+---------------+

我們可以按照訂單總額從高到低進行排序：

mysql>SELECT * FROM customers ORDER BY total_amount DESC;
+----+-----------+----------+---------------+
| id | name      | orders   | total_amount  |
+----+-----------+----------+---------------+
| 3  | Mike      | 10       | 1500          |
| 4  | Tom       | 8        | 1200          |
| 1  | Jack      | 5        | 1000          |
| 2  | Lily      | 3        | 800           |
| 5  | Sarah     | 4        | 600           |
+----+-----------+----------+---------------+

我們也可以按照訂單數從低到高進行排序：

mysql>SELECT * FROM customers ORDER BY orders ASC;
+----+-----------+----------+---------------+
| id | name      | orders   | total_amount  |
+----+-----------+----------+---------------+
| 2  | Lily      | 3        | 800           |
| 5  | Sarah     | 4        | 600           |
| 1  | Jack      | 5        | 1000          |
| 4  | Tom       | 8        | 1200          |
| 3  | Mike      | 10       | 1500          |
+----+-----------+----------+---------------+

我們還可以按照多個條件進行排序，例如按照訂單總額從高到低，如果訂單總額相同，則按照訂單數從低到高排序：

mysql>SELECT * FROM customers ORDER BY total_amount DESC, orders ASC;
+----+-----------+----------+---------------+
| id | name      | orders   | total_amount  |
+----+-----------+----------+---------------+
| 3  | Mike      | 10       | 1500          |
| 4  | Tom       | 8        | 1200          |
| 1  | Jack      | 5        | 1000          |
| 2  | Lily      | 3        | 800           |
| 5  | Sarah     | 4        | 600           |
+----+-----------+----------+---------------+

可以看到，我們可以根據不同的排序條件來排序一張表，這使得我們能夠更方便地查看、分析和處理數據。