I am working on a query:

Get the item_id, order_id, price from the order_line table where the price for an individual item's order is greater than the average of all orders for the item.

Here is what I have so far to get the average for all of the items:

SELECT order_id, AVG(price) FROM order_line
GROUP BY order_id

What can I do from here to get all of the prices (and item ids) where the price is greater than the average for each value?