Database: customers_campaigns_ecommerce
Question: Show the name and phone of the customer without any mailshot.
SQL:
SELECT customer_name ,  customer_phone FROM customers WHERE customer_id NOT IN (SELECT customer_id FROM mailshot_customers)