What are all the products?
select * from products
Which products are supplied by supplier id 3?
select * from product_suppliers as t1 join products as t2 on t1.product_id = t2.product_id where t1.supplier_id = 3
Give me the product type, name and price for these products.
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