Select customer_id, customer.name As customer_name, Count(*) From `order` Join customer On `order`.customer_id = customer.id Group By customer_id Having Count(*) > 1;