Database: customers_campaigns_ecommerce
Question: Show the names of customers who have the most mailshots.
SQL:
SELECT T2.customer_name FROM mailshot_customers AS T1 JOIN customers AS T2 ON T1.customer_id  =  T2.customer_id GROUP BY T1.customer_id ORDER BY count(*) DESC LIMIT 1