涉及MAX（）的更简洁的SQL查询

inventory
+------------------+-------------------+------------+
| DVD              | replacement_price |      stock |
+------------------+-------------------+------------+
| Pi               |              9.99 |        500 |
| Dune             |             29.99 |        100 |
| Heathers         |              4.99 |         20 |
| Jaws             |             19.99 |        500 |
| Mulholland_Drive |             39.99 |         50 |
| Waking_Life      |             29.99 |        200 |
+------------------+-------------------+------------+

rented
+-----------------+-----------+------------------+
| subscriber      | queue_nbr | DVD              |
+-----------------+-----------+------------------+
| Bob             |         1 | Mulholland_Drive |
| Bob             |         2 | Jaws             |
| Chey            |         1 | Pi               |
| Chey            |         2 | Heathers         |
| Jamie           |         2 | Mulholland_Drive |
| Jamie           |         4 | Dune             |
| Jamie           |         1 | Jaws             |
| Jamie           |         3 | Waking_Life      |
| Nora            |         4 | Jaws             |
| Nora            |         2 | Mulholland_Drive |
| Nora            |         3 | Dune             |
| Nora            |         1 | Waking_Life      |
+-----------------+-----------+------------------+
inventory
+------------------+-----------------