How to get the maximum price from another table?

Question

MySQL

There are 2 tables
items
id | name
history
id | item_id | price | date
How to get a table like
item_id | name | price (maximum price for this product in the entire table) | date

Answer 1

SELECT items.id AS `item_id`, items.name AS `name`, MAX(history.price) AS `max_price`, history.date AS `date` WHERE history.item_id = items.id;

Looks like it, if I'm not mistaken

Answer 2

SELECT item_id, items.name, max_price, date
FROM items
JOIN (SELECT item_id, date, max(price) max_price FROM history GROUP BY 1,2) t1
ON items.id = item_id