Django Queryset how to create such a query?

Question

Django

There are two tables
Goods and Price history
. It is necessary to display the last price by date from the price history table.
On Sqlite it will turn out, but I can’t figure out how to do it through Queryset

SELECT name,max(date),price,price_discount FROM polls_products
INNER JOIN polls_history_price on polls_history_price.product_id = polls_products.id
GROUP BY polls_products.id