And how much was their average amount purchased for each product?
select product_id, avg ( total_amount_purchased )  from Product_Suppliers group by product_id
average amount purchased for each product refers to AVG(total_amount_purchased);