CREATE TABLE product_suppliers (supplier_id VARCHAR(255), product_id VARCHAR(255)); CREATE TABLE suppliers (supplier_name VARCHAR(255), supplier_phone VARCHAR(255), supplier_id VARCHAR(255)); CREATE TABLE products (product_id VARCHAR(255), product_name VARCHAR(255))
List the names and phone numbers of all the distinct suppliers who supply red jeans.
    
SQL: 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"