Can you please provide me with a list of all customer names and phone numbers?
select t1.customer_name, t1.customer_phone from customers as t1 join mailshot_customers as t2 on t1.customer_id = t2.customer_id
Can you filter that list of customers to show only those who have 'No Response' as their outcome code?
select t1.customer_name, t1.customer_phone from customers as t1 join mailshot_customers as t2 on t1.customer_id = t2.customer_id where t2.outcome_code = "No Response"
Can you please provide me with the phone number and email addresses of these five customers?
select t1.customer_phone, t1.customer_email from customers as t1 join mailshot_customers as t2 on t1.customer_id = t2.customer_id where t2.outcome_code = "No Response"