Database: department_store
Question: Give me the product type, name and price for all the products supplied by supplier id 3.
SQL:
SELECT T2.product_type_code ,  T2.product_name ,  T2.product_price FROM product_suppliers AS T1 JOIN products AS T2 ON T1.product_id  =  T2.product_id WHERE T1.supplier_id  =  3