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
highest number of mailshots for customers refers to MAX(COUNT(mailshots));