Show the information for the product "red jeans".
select * from products where product_name = "red jeans"
Find all the distinct suppliers who supply red jeans.
select distinct * from suppliers as t1 join product_suppliers as t2 on t1.supplier_id = t2.supplier_id join products as t3 on t2.product_id = t3.product_id where t3.product_name = "red jeans"
What are their names and phone numbers?
select distinct t1.supplier_name, t1.supplier_phone from suppliers as t1 join product_suppliers as t2 on t1.supplier_id = t2.supplier_id join products as t3 on t2.product_id = t3.product_id where t3.product_name = "red jeans"