mysql - Avoid using a subquery in a table join

Question

In a MySQL 5.7 database, I have the following User table:

Name	Id
David	1
Frank	2

Answer 1

For every user, I want to select the price of the order with the biggest ID.

That looks like:

SELECT
  u.*,
  o.Price,
FROM 
  User u
  INNER JOIN Order o ON u.ID = o.UserID
  INNER JOIN 
  (
    SELECT MAX(ID) as OrderID FROM Order GROUP BY UserId
  ) maxO ON o.Id = maxO.OrderId