What is the total value purchased for supplier id 3
SELECT sum ( total_value_purchased )  from Product_Suppliers where supplier_id = 3
total value purchased for supplier id 3 refers to SUM(total_value_purchased) WHERE supplier_id = 3;