Can you tell me the highest number of mailshots for the customers?
select count ( * ) 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
What about the highest mailshot id number?
select t1.mailshot_id 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
What is the customer id for that mailshot id?
select t1.customer_id 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
How many mailshots does customer id 1 have?
select count ( * ) from mailshot_customers where customer_id = 1
What is the name of customer id 1?
select customer_name from customers where customer_id = 1
What is the amount of mailshots that Wendell has?
select count ( * ) from mailshot_customers as t1 join customers as t2 on t1.customer_id = t2.customer_id where t2.customer_name = "Wendell"