CREATE TABLE customers (customer_name VARCHAR(255), payment_method VARCHAR(255), customer_id VARCHAR(255)); CREATE TABLE mailshot_customers (customer_id VARCHAR(255), outcome_code VARCHAR(255))
What are the name and payment method of customers who have both mailshots in 'Order' outcome and mailshots in 'No Response' outcome.
    
SQL: SELECT T2.customer_name, T2.payment_method FROM mailshot_customers AS T1 JOIN customers AS T2 ON T1.customer_id = T2.customer_id WHERE T1.outcome_code = 'Order' INTERSECT SELECT T2.customer_name, T2.payment_method FROM mailshot_customers AS T1 JOIN customers AS T2 ON T1.customer_id = T2.customer_id WHERE T1.outcome_code = 'No Response'