Database: e_commerce
Question: What is the average price of the products being ordered?
SQL:
SELECT avg(T1.product_price) FROM Products AS T1 JOIN Order_items AS T2 ON T1.product_id  =  T2.product_id