Database: department_store
Question: Return the product type, name, and price for products supplied by supplier 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