What are the names of all the products supplied by supplier id 3, please?
select t2.product_name from product_suppliers as t1 join products as t2 on t1.product_id = t2.product_id where t1.supplier_id = 3
What are the product types of those?
select t2.product_type_code from product_suppliers as t1 join products as t2 on t1.product_id = t2.product_id where t1.supplier_id = 3
What are the prices of those?
select t2.product_price from product_suppliers as t1 join products as t2 on t1.product_id = t2.product_id where t1.supplier_id = 3
What are the prices of those?
select t2.product_price from product_suppliers as t1 join products as t2 on t1.product_id = t2.product_id where t1.supplier_id = 3
What supplier id carries the product name red jeans?
select t1.supplier_id from product_suppliers as t1 join products as t2 on t1.product_id = t2.product_id where t2.product_name = 'red jeans'
What is the total amount purchased of those?
select t1.supplier_id,t1.total_amount_purchased from product_suppliers as t1 join products as t2 on t1.product_id = t2.product_id where t2.product_name = 'red jeans'