-- selects customer, joins orders on customers' id, groups by the customer_id in orders and filters to > 1 orders
SELECT customer.name FROM customer INNER JOIN order ON order.customer_id=customer.id GROUP BY customer.id HAVING COUNT(*) > 1; 