What are the name and payment method of customers who have both mailshots in 'Order' outcome and mailshots in 'No Response' outcome.
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'